Automated Data Export In BigCommerce

black framed glasses above a paper with business data

Data export allows you to view your product, order, or customer data in spreadsheet form. From there, you can make any change and re-import it back into your store, or send order data to third-party accounting software. This is particularly useful for bulk editing and data storage. This article will look at 2 ways of exporting data via Atom8 and BigCommerce export function.  Auto-generate data into a spreadsheet by Atom8 Manually updating customer data is always possible. However, this becomes extremely daunting given the large number of orders per day. Besides causing fatigue, manual work is also prone to error, which might take a lot of time to fix. Thus the solution is to generate data right after the order is placed. This ensures accuracy while preventing missing out on any important information.  This can be done easily with the Atom8 workflow automation. For example, you want to add a customer to the VIP list when their total spending reaches $1000 and generate data into a spreadsheet for better storage.  One workflow example is: TRIGGER: When a customer places an order. CONDITION: After 5 days, check if the order status is completed AND the customer’s total spending is equal to or greater than $1000. ACTION: Assign the customer to the Platinum group AND add a row to the spreadsheet.  BigCommerce export function  BigCommerce allows merchants to export a wide variety of data, including products and product options, customers, orders, product SKUs, eCommerce analytics reports, and 301 redirects. The file is often in either the .CSV or .XML format. The CSV file is of better use if you wish to reimport data back to your store. You can find the export button under major store categories, namely orders, products, and customers. When exporting data, you will need to select an export template, which determines the fields that need downloading. BigCommerce recommends using the Default template for exporting Orders, and the Bulk Edit template when exporting Products and Customers. However, you can always customize your own template as long as it matches your purpose. A custom template will let you change formatting options, rename the headers, and include or exclude the fields. Remember to select Save export to the server for later download to save the file even if you encounter a timeout issue.  Final note Above are 2 ways to export data from BigCommerce that help you get rid of manual work. If you want to download a lot of information at the same time, you might want to use the BigCommerce export function. However, if you wish to update your spreadsheet every time new data is created, then Atom8 is a better option. Try the app today and enjoy the convenience!    

Buy Online, Pick Up In-Store In BigCommerce

a cashier waiting for customers to pick up in-store

Buy online, pick up in-store (BOPIS) has become a new commerce trend these days. Reports show that in 2020 more than 45% of top 500 retailers are offering BOPIS in their physical stores, an increase of 37% compared to previous years. This model is a blend of online and offline experience. On the one hand, it minimizes in-person interaction during the pandemic. On the other hand, it keeps customers from waiting for days to receive their package. Besides BOPIS, retailers might also use cousin models such as:  Curbside pickup or BOPAC: Customers order online and receive their items outside the store, often without leaving their car. BORIS: Buy-online-return-in-store. ROPIS: Reserve-online-pickup-in-store. This method allows customers to order an item for in-store pick, but not actually pay for it until they receive it. Benefits of BIPOS Reduce shipping costs Delivery from a retailer’s distribution center to a customer’s front door might be expensive, considering the labour and packaging costs. Therefore, by letting customers pick up items from the store, merchants can still offer a pleasant experience while saving up costs and time.  Incentivize customers to buy more One advantage of in-store purchase is that consumers might be tempted to buy more as they look around and browse for more products. It is also easier to upsell and cross-sell in person. That’s why BIPOS is like hitting two birds with one stone for retailers.  Better inventory management  With BIPOS, you don’t have to separate between online and offline inventory management anymore. Inventory can be updated from the distribution center or the store shelves, whatever faster, allowing for more centralized management.  How to set up BIPOS in BigCommerce Merchants can set up BIPOS in BigCommerce based on the local zone. This allows customers within a certain perimeter to pick up their packages in-store. For ROPIS, you need to install another in-store payment method as well.  1. Create a local shipping zone with the ZIP or postal code 2. Activate Pickup In Store function  3. Set up a workflow to tag PIBOS orders to distinguish them from other types of purchases. At the same time, send a confirmation email to the customers. Note that orders created with the in-store pickup method require offline transactions to occur, so they will need to be manually updated. 4. Order placed by customers using the in-store pickup method will have the status of Awaiting payment. Once the customer arrives and receives their package, go to View orders under the BigCommerce control panel and change the order status to completed. This is how you can set up buy online, pick up in-store with BigCommerce. This is a purchase method that might help improve your store performance. ANd it can be done easily with Atom8. Install the app today to explore more of its benefits. 

Get free consultation from our experts

Talk with GritGlobal’s experts to find the best operation solutions today!

Please enable JavaScript in your browser to complete this form.
Marketing
Privacy Policy
I understand that I can withdraw my marketing consent at any time by submitting an opt-out request via email support@gritglobal.io. By submitting this form, I acknowledge that I have read and understand the GritGlobal's Privacy Policy.