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
from source > http://www.support.mywork.com.au/OpenCart---ExportImport-Excel-File
Comments
Post a Comment