03 May 2013

OpenCart CMS - Export/Import Excel file


Categories

Categories looks like the most confusing to get your head around at the start however it’s fairly straight forward.

The technique to doing it is to add all your categories in first and assign a unique id to it and group the categories together.  It’s probably best to even work backwards too.

  • Category_id – the unique id of the category, you cannot assign multiple id’s to a category or assign a single id to multiple categories
  • Parent_id – the id of the category that the category belongs to.  ‘0’ is a top level category (the category that will be shown and that houses sub-categories etc)
  • Name – the name of the category
  • Sort_order – if you want categories to appear in a specific order you can number them, just remember if you don’t assign a number to a category it will default to ‘0’ which will place it before all the other categories in that particular level / sub-category
  • Image_name – the image that is assigned to the category.  See additional images in products section for example and explanation
  • Date_added – put today’s date
  • Date_modified – put today’s date
  • Language_id – keep at 1 (English)
  • Seo_keyword – similar to meta_keywords
  • Description – the description of the category
  • Meta_description – a brief concise description of the product / category to help with search engines
  • Meta_keywords – keywords that are specific to the product / category, to help with search engines
  • Store_ids – keep at ‘0’, don’t change
  • Status enabled – whether or not a product is enabled or disabled (shown or hidden) true = shown, false = hidden


Products

With products, only the product name is a mandatory field, you can leave as many areas blank as you like.  You don’t need to fill them all in.

Product_id – the unique id of the product, you cannot assign multiple id’s to a product or assign a single id to multiple products

  • Name – The name of the product
  • Categories – the categories that the product belongs to.  You can add a product to multiple categories,  just separate category id’s with a comma (eg. 23, 56, 5)
  • Sku – the SKU number of the product (SKU’s are assigned to barcodes to allow for easy identification when scanned)
  • Location – the location of the product (eg. Brisbane, Australia)
  • Quantity – the about of the product that you have in stock
  • Model – the model number of the product
  • Manufacturer – this is the brand of the product (for example, windows 7 is a Microsoft product so you’ll add in ‘Microsoft’ and people will be able to search for products by manufacturer) note: you can only have one manufacturer
  • Image_name – same as additional images (see for example)
  • Requires shipping – set to yes unless it’s a digital download
  • Price – the price of the product (before tax)
  • Date_added – put today’s date
  • Date_modified – put today’s date
  • Date_available – put today’s date unless it will be available at a specific date.
  • Weight – weight only needed if you have a shipping method that is weight based (eg AusPost) also be sure to keep the weight in kilograms (eg. 250g = 0.25)
  • Unit – keep at ‘kg’
  • Length – not needed for anything but you can add it if you like
  • Width – not needed for anything but you can add it if you like
  • Height – not needed for anything but you can add it if you like
  • Length unit – keep at ‘cm’
  • Status enabled – whether or not a product is enabled or disabled (shown or hidden) true = shown, false = hidden
  • Tax_class_id – keep at ‘9’ (GST)
  • Viewed – number of times the product has been viewed (leave blank)
  • Language_id – keep at 1 (English)
  • Seo_keyword – similar to meta_keywords
  • Description – the description of the product / category (the description is in HTML however don’t be afraid of this, all you need to do is have a at the start of each paragraph and an at the end of each paragraph and that will format it.  If you want bold add around the words you’d like in bold and for italics.
  • Meta_description – a brief concise description of the product / category to help with search engines
  • Meta_keywords – keywords that are specific to the product / category, to help with search engines
  • Additional images – the links to additional images for a product, if there are additional images for a specific product, add a comma after each image url, don’t add spaces.  Start all links with data/(name of folder that will contain the image)/(image name)
  • Stock_status_id – this is the status that is shown when a product is out of stock (keep at ‘5’ which is the default ‘out of stock’)
  • Store_ids – keep at ‘0’, don’t change
  • Related_ids – id’s of products that are related to a specific product
  • Tags – tags act as keywords, however it will list them at the bottom of the product page and if someone clicks on a specific keyword, then all the products with that tag will be grouped and displayed.  (add commas between each tag)
  • Sort_order – if you want products to be displayed in a specific order
  • Subtract – whether or not it will subtract from the products stock number when purchased
  • Minimum – the minimum amount of a specific product that the customer has to buy when purchasing the product
  • Cost – the cost price of the product  (not needed)


Options

This area is for additional options that a product might have.  For example, a shirt will have shirt sized of small, medium, large, etc, etc.

  • Product_id – the product id number that this option will belong to.
  • Language_id – keep at 1 (English)
  • Option – the name of the option (eg shirt sizes)
  • Option_value – the options of the product (eg small, medium, large)
  • Quantity – the quantity of stock of the option (you can leave blank if you don’t have to worry about stock quantities)
  • Subtract – whether or not it will subtract from the products stock number when purchased
  • Price – the price difference of the option to the base product (for example of the additional option is $50 more then it will be 50)
  • Prefix – add a ‘+’ or ‘-‘ here to indicate whether the above price subtracts from or adds to the base product price.
  • Sort_order – the order of which you’d like the individual options to be listed


Specials

  • Product_id – the product id number that this discount/special will belong to.
  • Customer_group – if you have customer groups, for example the store has retail set as the default however if you were to add wholesale it too you can set the discount/special for a specific group only.
  • Priority – priority of discounts
  • Price – price of product after discount (eg. $500 product has $50 dicount, price = $450
  • Date_start – starting date, must be in this format – yyyy/mm/dd
  • Date_end – ending date, must be in this format – yyyy/mm/dd


Discounts

  • Product_id – the product id number that this discount/special will belong to.
  • Customer_group – if you have customer groups, for example the store has retail set as the default however if you were to add wholesale it too you can set the discount/special for a specific group only.
  • Quantity – I think this is in reference to the amount that can be bought at the discount price before it ends (just leave it blank)
  • Priority – priority of discounts
  • Price – price of product after discount (eg. $500 product has $50 discount, price = $450
  • Date_start – starting date, must be in this format – yyyy/mm/dd
  • Date_end – ending date, must be in this format – yyyy/mm/dd
Post a Comment