Ordergroove receives product catalog data — product name, ID, price, image URL, etc. — from a product feed within our apps, integrations, and cartridges. Our Product Configuration Tool takes this data and combines it with the Ordergroove-specific configurations for each product.
Overview
The Product Configuration File takes the form of a CSV that can be opened in any editor — such as VS Code or LibreOffice — to input your data will help avoid these formatting issues. However, please observe the following conditions regarding the formatting of product IDs.
Note: Microsoft Excel does not respect leading zeros. If you have product IDs with leading zeros — such as "0001" — Microsoft Excel will omit them (and display them as "1") and you will not be able to update your product configurations. To avoid this, convert the column to Text format before saving to ensure leading zeros aren’t dropped.
Files should be saved and encoded with UTF-8 without BOM.
Step 1: Download The Configuration File
After you submit your Product Feed to Ordergroove, you can use the Ordergroove Product Catalog to set and update the default subscription settings for your products.
-
To access this tool, use the navigation bar to visit Data > Products and click Export on the top right.
- Ordergroove will download a CSV Spreadsheet containing all of your products.
Step 2: Update The Product Settings In The File
Open the newly downloaded file and adjust the values in the fields to align with the information regarding your products and how you wish to sell them via Ordergroove.
⚠️ Formatting Your Spreadsheet
- Product Configuration File Definitions has a list of the fields (spreadsheet columns) and values.
- Product IDs must be formatted as numbers/text. Microsoft Excel will automatically reformat IDs formatted as text to scientific notation, which Ordergroove will not recognize.
- Before you upload the file back into Ordergroove, you will need to reformat the Product ID column. You can do that by highlighting column A, right-clicking and choosing Format Cells, then choose Numbers with 0 decimal places.
If you have any further questions about this file or the definitions in it, please feel free to reach out to Ordergroove support.
Step 3: Upload The Updated Configuration File
- Once you have the necessary changes to your configuration file, return to the Products page under Data > Products and click Import on the top right.
- Drag and drop your file into the box, or click the Click to upload text to select your finalized, configured CSV to upload. After choosing your file click Import. A notification will appear in the lower left-hand corner to acknowledge the successful file transfer.