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:
| Field | Restrictions | Details |
|---|---|---|
| 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:
You should check any special characters in the product code and ensure that they display correctly on the website. Special Characters can also cause issues in integrations with 3rd parties.
|
| Title | MAX 100 chars |
The product title should be web friendly.
Product titles are important for clarity to the customer but also extremely important for SEO - so that your product will be found on google and other search engines.
|
| PriceEURO |
The main price on the website. If there is a discounted price (PromotionPriceEURO) then PriceEURO will be the "Was" price. |
|
| 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
IMPORTANT: These DESCRIPTION fields must be HTML (if it is more than 2 or three lines of text) so they must include all formatting converted into raw HTML.
There are two ways to add descriptions
- Editing the content directly on the product detail page using LIVE EDIT. This is easy to use, similar to using WORD but it writes html in the background. You don't need to know html to use this.
- Bulk importing the SHORT and LONG DESCRIPTION fields. 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 and simple - that it doesn't have html that will cause issues on the website. A basic understanding of html is required for this.
The following are some examples of HTML which you can use in your descriptions:
Text using paragraph tags
<p> This is a heavy-duty hand tool designed with a hardened all-metal core and multiple striking caps for enhanced durability and increased force during prying and chiseling tasks.</p>
If your description is wordy breaking it into multiple paragraphs will help make it more readable to your customers.
Bullet Points
Use <ul> and <li> tags eg
<ul><li>Feature 1</li><li>Feature 2</li><li>Feature 3</li><li>Feature 4</li></ul>
Bold
This is some sample <strong>bold</strong> text</p>
Sub headings within your description
If you would like to add a sub heading within the description we suggest that you use a h4 heading eg
<h4>Key Features</h4>
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>
HTML which has custom html from another website (eg classes, ids, style attributes) or incorrectly formed html can cause issues
- override the design of the website and display descriptions with different fonts, font sizes etc which make your website look unprofessional (and reducing confidence in your website)
- Interfere with the code on the website and therefore cause issues with the workings of the website.
So it is important that html is cleaned before being added to the website.
Also ensure that descriptions are mobile friendly - avoid big tables which will not display well on mobile.
Take care where you source descriptions. Make sure you have permission to use the descriptions on the website. Don't copy descriptions from a competitor website - as this will not help with the page ranking on google and other search engines. You may wish to use AIVA Description Generator on the product page to generate unique descriptions.
The following are the short and long description fields.
| Field | Restrictions | Details |
|---|---|---|
| ShortDescription | MAX 250 characters | “Short Description” on website, a one liner - most retailers don't bother with this. |
| ShortDescription2 | MAX 2,500 characters |
“Additional Info” on website, appears in the first item of the accordion underneath the add to basket. This is the recommended location for the main description of the product. This description generally goes to google in the product feed.
|
| LongDescription | MAX 50,000 characters | The "Long Description" on website underneath the product image. This descriptions is less visible that shortDescription2. Use as a last resort. Please talk to magico support team/helpdesk@magico.com if you are considering using this. |
|
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”) Please talk to magico support team/helpdesk@magico.com if you are considering using this. |
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.
| Field | Restrictions | Details |
|---|---|---|
| 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
|
|
| EnergyRating |
Accepted values are:
|
|
|
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 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 |
Comments
0 comments
Please sign in to leave a comment.