CSV / Google Sheets
In this guide, we'll walk you through the process of integrating your inventory and pricing data using CSV / Google Sheet.
Last updated
In this guide, we'll walk you through the process of integrating your inventory and pricing data using CSV / Google Sheet.
Last updated
To get started, you will need to setup a 'cron job' for your Product Feed and export it to the Google Sheets link provided by DSTNC. A cron job is an automated task programmed to execute at specified intervals. This automation will help keep your Product Feed continually updated.
Create Your Product Feed: Your Product Feed should include all the necessary information about your products. Export this information in a CSV format using the guidelines specified in the below. Make sure all fields are properly filled out.
Set up a Cron Job to Automate Product Feed Export: Once you've created your product feed, you need to create a ‘cron job’ that is set to regularly export your feed in CSV format and replace the data in the Google Sheets link provided by DSTNC. This shared Google Sheets link will serve as an end-to-end data point to sync inventory and prices between your online store and DSTNC. We recommend running the ‘cron job’ at intervals of 1 hour or a minimum of every 3 hours. This will ensure that the product information is kept up-to-date and accurate and will prevent overselling of out-of-stock items.
There are many options to create a ‘cron job’ of product feed from your e-commerce platform. While some platforms offer this functionality as a built-in feature, others may require you to install an extension or app.
If you're not already utilizing one of the apps or extensions on your e-commerce platform to schedule automated product feed exports, we highly recommend creating automation (cron job) with a feed generator tool like or . This will make it easier for you to keep your inventory and pricing data up to date without having to update the Google Sheet CSV manually. DSTNC is utilizing both tools, and we can help with the setup process.
Create a ‘cron job’ export of your products with the following values:
'’
‘’
‘’
‘’
‘’
View template:
name The name of the product or the product title as appear on your online store. For example: ‘Core Bib Shorts’ or ‘Long Sleeve Jersey’.
sku (Stock Keeping Unit) is the unique code or number you use to identify and track individual products or items in your inventory management. Each SKU typically corresponds to a specific product variant, such as a different size or color.
qty The quantity of each product variant you currently have on hand.
retail_price The current price of the product on your online store in USD.
compare_at_price Is the original price of a product before a discount or sale is applied. This value is typically shown alongside the discounted price on the product page. For example, if a product originally cost $50 but is currently "on sale" for $40, the "compare_at_price" would be $50 and the "retail_price" would be $40.
If the product is not currently discounted ("on sale"), then make sure the "compare_at_price" column is left blank.