Exporting other CSV Files
There are other optional csv files that you can export. The full details of all files you can export and the full list of fields available to you are detailed under the UPLOADING DATA / CSV FILES section.
For all files, filter on the “Active on Web” Checkbox
When exporting products from your ERP/ePos, only export the products that have been made “Active for Web”. See if there is a checkbox in your ERP/ePos for “Active on Web” or something similar and add a filter to your products export so that only products with this checkbox ticked are included in your list of products. If you cant find an appropriate checkbox, then add a custom field to your products table as a TRUE/FALSE checkbox with the title “Active on Web”.
Similarly, for the PRODUCT CATEGORY RELATIONSHIPS file, also ensure that only products with “Active on Web” are included in this file.
A similar process will also be used for uploading other CSV files in the future – e.g. customers, price plans and other CSV files will only include customers and products that have been checked as “Active on Web” (as if we are exporting customers, we will look to use an “Active for Web” checkbox in the customers table).