Full List of Product Fields – AB Commerce Online Help

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. There are some characters which cause an issue in the product code. The following characters cannot be used in the product code The forward slash (/) The plus sign (+) You should check any special characters in the product code and ensure that they display correctly on the website.
Title	MAX 100 chars	The product title should be web friendly. Avoid abbreviations that the customer will not understand. Ensure that the title has enough detail to fully identify the product. Generally titles start with the brand.
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
ShippingBandNumber		A number between 1 and 10. 1 should be the cheapest band.

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.

If you would like to upload HTML by bulk import then please contact helpdesk@magico.com and we will work with you to ensure that your html is clean - that it doesn't have html that will cause issues on the website.

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

This is some sample bold text

Mixture of bullet points and bold text

This is some sample bold text:
<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 2^nd 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 BULKY shipping rate. Note if using shipping bands you will also need to set a more expensive shipping band on the product. IsBulky will also add signage to to the product page indicating that this is a bulky product.
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.
Keywords	Max 4000 char	Keywords are used for internal site search (AB Commerce advanced search). Separate your keywords with a comma. A max of 50 keywords for a product will be used.

Google Fields

The following are additional optional fields that can be used for Google Shopping, Facebook, Instagram and other integrations:

GTIN	MAX 50 chars	See this article for more details
Google_Material	MAX 200 chars	See this article for more details
Google_Pattern	MAX 100 chars	See this article for more details
Google_Color	MAX 100 chars	See this article for more details
Google_Size	MAX 100 chars	See this article for more details
Google_Gender	MAX 10 chars	See this article for more details
Google_AgeGroup	MAX 10 chars	See this article for more details

Related articles