Required | Column Name | Description |
YES | ID | Please leave this blank or set to ‘0’ |
YES | Show on Website | Set to TRUE – shows the product on the website |
YES | Show on Google | Set to TRUE – shows the product on Google Shopping |
YES | SKU | Ngage SKU – please format as follows: If a product has multiple variations like a T-shirt has colours and sizes, there should be a row of data for each variation, the SKU, Title Content etc should all be the same for each variation, the only things changing would be the variation one, variation two, manufacturer code and maybe the costs. 2 letter manufacturer abbreviation 2 – 8 letter product abbreviation Example: Manufacturer = Reebok Product Title = Vest T-Shirt SKU = RB-V-TS |
YES | Title | The product title – do not include variation information like colours or sizes |
YES | Variation One | Generally, this would be a colour for a t-shirt example |
NO | Variation Colour Value | Only required if your website is using a colour picker on the product page to select a variation, this would be a HEX colour code |
YES | Variation Two | Generally, this would be a size for a t-shirt example, if you have a product that has no variation two, you can use the text ‘DEFAULT’ which will omit the variation from the website |
NO | Web Order Min Qty | Minimum amount a customer is required to order |
NO | Web Order Max Qty | Maximum amount a customer can order at one time |
NO | Web Qty Label | The label that is displayed above the qty entry box, leave blank, default is ‘Qty’ |
YES | Manufacturer | The Manufacturers Name, clicking this cell will popup a selection, if the name is not present in the list, please refer to tab 1 ‘Data’ and populate column B Manufacturers, this will populate the selection list. |
YES | Manufacturer Code | The unique code assigned to a product variation by the manufacturer, must be different for every row of data |
NO | Replen Min Stock | If you are using the Purchase Ordering module, min amount before the trigger fires to order more stock via the PO system |
NO | Replen Order Qty | If you are using the Purchase Ordering module, the amount to order when generating a PO |
YES | Selling Price | The price to sell on the website (exclude tax) |
NO | Selling Offer Price | The price will cross out the Selling Price and display the offer price below |
NO | Selling Trade Cost | If a customer is marked as a trade customer, this is the price they will see once logged in |
NO | RRP Price | Sometimes displayed on the website |
YES | Buying Cost | Required if the Ngage profit report and accounting package sync is used |
NO | Price Override Label | Sometimes manufactures will not let you display a price on a website, this can be used to replace the price with text, example: ‘Please call for a price’ |
YES | Tax Exempt | At checkout tax is automatically calculated, if this is set to TRUE, then the product will not have tax applied |
NO | Stock Level | If you are using stock level management, then depending on the Stock Level Action, product will not be available to purchase (see stock level action below) |
YES | Barcode | The unique barcode assigned to a product variation by the manufacturer, must be different for every row of data |
NO | Bin Location | The storage bay/bin where the product is being held, shows up on the warehouse app when picking orders |
NO | Available Date | If you want to display your product but don’t want purchase to be available until a specific date time, populate this date |
YES | Shipping Size | Custom Option for custom shipping data |
YES | Shipping Options | Select an option from the list, only these options will be available at checkout if this product is in the basket. |
YES | Product Weight (grams) | Must be set in grams – required for shipping calculations |
YES | Product Height (cm) | Must be set in cm – required for shipping calculations |
YES | Product Width (cm) | Must be set in cm – required for shipping calculations |
YES | Product Depth (cm) | Must be set in cm – required for shipping calculations |
YES | Variation One Label | The label that is displayed above variation one, default = ‘Please select a colour’ |
YES | Variation Two Label | The label that is displayed above variation one, default = ‘Please select a size’ |
YES | Meta Title | Extremely important for SEO – at worst can be a copy of your product title, must be unique for every SKU |
YES | Meta Description | Extremely important for SEO – at worst can be a copy of a few lines of the content, must be unique for every SKU |
YES | Content | The main content for the product, clicking in this cell will pop up a content editor, enter your content to save HTML |
NO | Specifications | If your website is using the specifications tab, then populate this with relevant content, clicking in this cell will pop up a content editor, enter your content to save HTML |
NO | Related SKU's | On a product page will show any related product at the bottom of the page, format is comma delimited, example: RB-V-TS, AD-V-TS |
NO | Pick Note Info | Information required to be displayed on the Pick Note at product level, example: manufacturing notes |
YES | Website Category | Clicking in this cell will pop up a selection, please select 1 category, only 1 category can be selected, due to SEO duplication issues |
NO | PO Supplier List | If you are using the Purchase Ordering module, these will be the suppliers you purchase the product from |
NO | Stock Level Action | Clicking in this cell will pop up a selection, this is the action when the stock level hits zero, what can the customer do |
YES | Stock Filters | Clicking in this cell will pop up a selection, you can select multiple filters, these are displayed in a few different ways on the website to filter a product selection |
NO | Image URL List | If you have images already hosted on a website, the system can automatically pull the image into our system, comma delimited list of URLs direct to the image file. |
NO | Variation Image URL | If you have images already hosted on a website, the system can automatically pull the image into our system, one URL direct to the image file. |
NO | Delete Variation | If trhe is selected here, the current variation will be deleted when the file is uploaded. |