What do the import/export table columns represent in Mews POS?

Although many columns exist in the products import (.CSV) / export file (.CSV or .XLSX), you do not need to fill in all values. The blank columns will be ignored in import, as well as the ones not defined by the original header. 
 

Note: It is important to leave the original header unchanged (the first row of the table).
 

 

• id, variant_id: Mews POS generates these values as unique ID's for each product. Do not change them in the exported file or leave the cells blank in case of adding new products to the product list.
• sku: SKU (Stock Keeping Unit) number.
• composite_handle: This column directly refers to a component name in a composite item. For each component, an extra row will be created.
• composite_sku: Stock Keeping Unit number of a composite item component.
• composite_quantity: The quantity of a component used in a composite item (e.g. a shot of vodka in a mixed drink: 0.025l).
• composite_unit: The unit of a component used in a composite item (e.g. litre, box, bottle, piece...).
• handle: This field is mandatory, it is your unique product ID.
  • You can use lower and upper case letters as well as the underscore (_) to handle title characters. Special characters and spaces are not allowed.
  • Product variants will have the same handle as the product. A handle is also used as a part of a URL for the product in the web store.
• name: This column is mandatory, it contains a product name. For variants, enter the same value.
• description: Webshop item descriptions, written inside HTML paragraph tags (<p>like this</p>).
• category: It's the category name to which the product is assigned to. There is no need to create the categories before the import, they will be created automatically.
• variant_option_one_name, variant_option_one_value, variant_option_two_name, variant_option_two_value, variant_option_three_name, variant_option_three_value: These are the name/value pairs that define the product variants.
  • For example, enter ‘colour’ under the variant_option_one_name for the variant name colour column (for this product) and copy-paste the entire row for each value.
  • If a variant has two values (e.g. green and black), add one additional row and enter 'green' in one row and 'black' in a second row under the variant_option_one_value column.
  • Don’t forget to copy/paste the product handle for the variant and all its values.
• retail_price_excl_tax, retail_price_incl_tax: 
  • These columns represent the retail prices with or without tax.
  • Only one of those two columns is necessary since the other one can be calculated.
  • If a tax is included, enable the slider 'All taxes are included in my prices' in your merchant profile (Settings -> General -> Edit Merchant) on the web dashboard.
  • Leaving these columns blank will create a product with a variable price.
• taxes: This is the tax handle, e.g. for the VAT 20% enter ‘vat_2000’.
  • If there is more than one tax applied to the product, separate it with a comma, e.g. When using VAT 20% AND VAT 3% enter ‘vat_2000,vat_300’.
• regular_retail_price: If you have a product on sale , the regular retail price will be stored here.
• weight: The product weight (in kilos). This value is used to calculate the product shipment price in the webshop.
• barcode: Enter the product barcode in this field if you are using a barcode scanner.
• tile_label: The label displayed on the product tile (four-character-format), e.g. PKV4
• tile_color: Colour of the tile (HTML colour code) that appears next to the product name in the product list or as a product shortcut.
• purchasable, sellable: The values of these columns can be either 'true' or 'false'.
  • Set the value of this cell to ‘true’ in 'purchasable' column if this is a purchasable item.
  • Apply the same criteria for 'sellable' column.
• inventory_tracking: The values of these columns can be either 'true' or 'false'. Set the value of this cell to ‘true’ if you want to track this product in an inventory.
• inventory_web_warehouse: Stock amount.