Filter Products on EXPORT TO WEBSITE
For the products extract, it is important that a CHECKBOX is set up called “Activate for Web” (or something similar like “Show On Website”) so that only products that have this checked are included in the product extract. This is to avoid:
- Products being set up on the website that are not intended for the website.
- Allows products to be uploaded into the holding area on the website in manageable batches.
Removing Products from the Website
To remove a product from your website, uncheck the “Activate for Web” checkbox so that the product is filtered out of the CSV file. The website will automatically deactivate the product and activate it again if you decide to check the “Activate for Web” checkbox anytime in the future.
Don’t ever delete a product off your back-end unless that product will never be on the website again as once you delete a product, all the product imagery and descriptions will be lost forever.
Careful of Double Quotes in CSV File
Ensure that your columns in the CSV file are surrounded by double quotes and that any double quote within the field is doubled up within the value.
For example, the following is an example CSV file with 3 products with one of them having a double quote in the title:
"ProductCode","Title","PriceEURO"
"A1234","Sample Product","49.99"
"B2345","Sample Product 2","149.00"
"C3456","Sample Product 3 – 6"" pipe","29.00"
File Naming Standard
The following is the name of the CSV file that you can export:
|
CSV File |
|
|
|
Products |
products_YYYYMMDDHHMMSS.csv (e.g. products_20180108172804.csv) |
Only send products ENABLED FOR WEB
Every 15 minutes |
Fields in the CSV File
The following are the main fields to include in the CSV file:
|
ProductCode |
MAX 50 chars |
The unique product code |
|
Title |
MAX 100 chars |
This is normally the TITLE or DESCRIPTION field in your ePos/ERP.
To make this title more descriptive on the web, it would be a good idea if this was auto-generated using extra fields like the BRAND/MANUFACTURER field as well as the TITLE/DESCRIPTION field – e.g. “BrandTitle – Title” (separated by hyphens and a space either side of the hyphen) |
|
PriceEURO |
|
|
|
PromotionPriceEURO |
|
If there is a discount being offered, this field has the discounted price – otherwise, this is zero |
|
PriceSTG |
|
|
|
PromotionPriceSTG |
|
|
|
PriceUSD |
|
|
|
PromotionPriceUSD |
|
|
The following article lists all additional optional fields that can also be included:
Click to view Full List of Product Fields
Comments
0 comments
Please sign in to leave a comment.