Standard Fields
The following are the main fields to include in the CSV file - note that you would only include one currency price field (either EURO, STG or USD, not all three) + the promotional price field is optional:
ProductCode |
MAX 50 chars |
The unique product code. The forward slash (/) cannot be used in the product code. |
Title |
MAX 100 chars |
|
PriceEURO |
|
|
PromotionPriceEURO |
|
If there is a discount being offered, this field has the discounted price – otherwise, this is zero |
PriceSTG |
|
|
PromotionPriceSTG |
|
|
PriceUSD |
|
|
PromotionPriceUSD |
|
|
PromotionPriceDiscountPercentage |
|
Set the percentage discount eg 10 or set as 0 to remove this discount. |
PromotionText |
|
|
Active |
|
TRUE or FALSE. If a new product is added without this field, it defaults to an active product. |
TradePriceEURO |
|
The trade price in Euro |
Description Fields
The following are the short and long description fields.
IMPORTANT: These DESCRIPTION fields must be HTML so they must include all formatting converted into raw HTML. Therefore, we would strongly recommend not bulk importing the SHORT and LONG DESCRIPTION fields and instead, editing the content directly on the product detail page using LIVE EDIT as it's simple to use and like using a WORD EDITOR.
The following are some examples of HTML:
Bullet Points
<ul><li>Feature 1</li><li>Feature 2</li><li>Feature 3</li><li>Feature 4</li></ul>
Straight Text with bold
<p>This is some sample <strong>bold</strong> text</p>
Mixture of bullet points and bold text
<p>This is some sample <strong>bold</strong> text:</p>
<ul>
<li>Feature 1</li>
<li>Feature 2</li>
<li>Feature 3</li>
<li>Feature 4</li>
</ul>
ShortDescription |
MAX 250 characters |
“Short Description” on website |
ShortDescription2 |
MAX 2,500 characters |
“Additional Info” on website, appears in the first item of the accordion underneath the add to basket. |
LongDescription |
MAX 50,000 characters |
The "Description" on website |
ShortDescription3 ShortDescription4 ShortDescription5 |
MAX 2,500 characters |
Optional extra short descriptions, these appear in the accordion underneath ShortDescription2. |
LongDescription2 LongDescription3 LongDescription4 LongDescription5 |
MAX 50,000 characters |
Optional extra long descriptions (e.g. “Technical Spec”) |
Stock Control Fields
The following are the stock control fields. See the article on updating stock levels for how to set the actual stock quantities.
StockControlLowStockQuantity |
|
If you would like to set a quantity level where “In Stock” is changed to “Low Stock” or “Our of Stock”, enter the quantities here – the default is that the product appears as “In Stock” until it goes down to a quantity of zero when it changes to “Out of Stock”. |
StockControlLeadTimeInStock StockControlLeadTimeOutOfStock |
When these are set, the product will always show as IN STOCK but have “Allow X days for delivery” based on the numbers in these 2 fields and whether the product is in stock or out of stock |
|
StockControlNextAvailableDate |
Date |
In the format “10 Jan 2018” – if this is set, and the product is OUT OF STOCK, then the words “Next Available Date: XXX” will appear beside the product |
StockControlOutOfStockQuantity
|
Integer |
This is the quantity at which the stock message on the site changes from Low Stock/In Stock to Out of Stock. For example you might set this field to 1 on a product to ensure that the display model is not sold. |
DisplayAlways | True or False |
Always display this product even if out of stock (Only if out of stock products configured to not display). |
OutletBufferQuantity | Integer |
For Outlet Stock Only: When integrating stock levels for outlets, you can set a buffer quantity to cater for items that may be picked off the shelves at the same time as online orders being made - e.g. if this is 2, and the quantity for the outlet is 5, it will only allow selling 3 items |
Additional Fields
The following are additional optional fields that can also be included:
TaxCode |
MAX 20 chars |
Not normally needed for B2C websites as the price above includes VAT
|
BarCode |
|
|
Rating |
Integer between 0 and 100,000 |
When displaying a list of products (e.g. all products in a category), the website sorts the list of products by RATING DESC and then TITLE ASC – so if you want to dictate the products that appear at the top of the list, pass in this field. |
|
|
|
IsNewUntil |
|
When this date field is set, we will display an IS NEW icon beside the product until this date is reached.
If this field is not passed in, we will automatically generate this date from the date the product is first uploaded to the website (they would remain as NEW for 45 days after they are first uploaded and the most recent uploaded products are sorted at the top of the NEW products list).
IMPORTANT: Use date format as “1 Jan 2018”
|
IsNewFrom |
|
This is AUTOMATED if left blank or not included in the file.
NOTE: The “Is New FROM Date” is for sorting the products under the NEW CATEGORY as the later FROM Dates are stored at the top of the list of new products
|
|
|
|
Clearance FurtherReduced Exclusive BestSeller BlackFriday
CustomIcon1 CustomIcon2 CustomIcon3 CustomIcon4 CustomIcon5 |
True or False |
When these are set to TRUE, the product will automatically appear with an icon over it displaying “Clearance” or “Best Seller” – and the product can also appear in some automated categories like “Clearance”.
There are also up to 5 custom icons allowed - and these can also be updated. |
DisablePurchase |
True or False |
When TRUE, the user is not allowed to add to their basket |
IsDiscontinued |
True or False |
When TRUE, the product is still displayed on the website but is not available for purchase |
ReplacementProductCode |
Max 50 chars |
If this product is discontinued, and there is a value in this field, this will show a link to the new product on top of this product’s image |
|
|
|
DiscountsDisallowed |
True or False |
If set to TRUE, this is excluded from promotional discounts |
Weight |
Numeric |
Can be used for calculating shipping rates |
SupplierCode |
Max 50 chars |
Can enter a 2nd product code here which is the supplier’s own product code |
CommodityCode |
Max 100 chars |
Can enter another product code here which is used for customs control |
MinimumOrderQuantity |
Numeric |
PRODUCT LEVEL ONLY - NOT SET AT VERSION LEVEL: If set to a value above zero, this will be the minimum number of items allowed to be purchased |
MaximumOrderQuantity |
Numeric |
PRODUCT LEVEL ONLY - NOT SET AT VERSION LEVEL: If set to a value above zero, this will be the maximum number of items allowed to be purchased |
RRPEURO RRPSTG RRPUSD |
Numeric |
If you want to display an RRP price (purely for display purposes), you can add one of these fields for the base currency of your website |
FreeDelivery |
True or False |
To enable free delivery on an item use True. To remove free delivery on an item use False. |
IsBulky |
True or False |
Set to TRUE to move a product into the BILKU shipping rate. |
CollectionOnly |
True or False |
Set to TRUE if product can only be collected (not shipped to) |
ExternalURL1 ExternalURL2 |
Max 250 chars |
These are the 2 video urls for a product |
SEODescription |
Max 4000 chars |
Replaces the automatically generated SEO Description as detailed in https://support.abcommerce.com/hc/en-us/articles/360015331931-SEO-How-my-website-looks-in-search-results. Ensure that this SEO description is an improvement on the one generated automatically. If using versions ensure that the SEO Description is added to the parent product. |
SEOTitle |
Max 150 chars |
Replaces the automatically generated SEO title as detailed in https://support.abcommerce.com/hc/en-us/articles/360015331931-SEO-How-my-website-looks-in-search-results. Ensure that this SEO description is an improvement on the one generated automatically. If using versions ensure that the SEO Title is added to the parent product. |
StatusMessage |
Max 250 char |
A general status message to be displayed with the product. |
Google Fields
The following are additional optional fields that can be used for Google Shopping, Facebook, Instagram and other integrations:
GTIN |
MAX 50 chars |
|
Google_Material |
MAX 200 chars |
|
Google_Pattern |
MAX 100 chars |
|
Google_Color |
MAX 100 chars |
|
Google_Size |
MAX 100 chars |
|
Google_Gender |
MAX 10 chars |
|
Google_AgeGroup |
MAX 10 chars |
Comments
0 comments
Please sign in to leave a comment.