Add New Products Using Opencart Bulk Export and Import Products from Excel

1. Add New Products Using Opencart Bulk Export and Import Products from Excel

2. Opencart import/export extension provides facility add and updated products in all available store language. Opencart import products from excel extension provide a demo product excel sheet. With the help of this demo sheet users easily create a product excel sheet. Opencart import products also provide information related to “Maximum time allowed for Import” and “Maximum file size allowed for import”. Opencart import/export extension provides an export product facility on one click. for updated product information first, you export all products and change product information in an excel sheet and checked Overwrite existing Data after that import the sheet.

4. How add Products For Add product in bulk first of all you will install product import-export plugin for Opencart with the help of a user guide. After installation, Login to the Admin Panel and Purpletree Product Export & Import menu. Click on it and select   Purpletree Product Export & Import. You will reach on Purpletree Product Export & Import page. On top, it shows the Maximum time allowed for upload and Maximum file size allowed for upload. Make sure values are high enough configured on your server for bulk data to import. Import Product Data Use the Exported data excel sheet or “Download Template”  to import new products or to edit any products. The exported Datasheet will have 13 tabs for all data. First of all Select Language from the list. If you want to add new product data and not sure if it already exists simply use the exported sheet format and add data accordingly. Click on the Import button. Click on Overwrite existing Data checkbox if you want to update previous values on product information. In General and Data Tab, during uploading data, if any error occurs. No product data row will be inserted or updated for that particular product id in any of the tabs afterward.

5. General This tab contains general data related to product like product_id, name, description, tag, meta_title, meta_description, meta_keyword. Data This tab contain add_product, product_id, model, SKU , UPC, EAN, Jan, ISBN, mpn, location, stock status, image, manufacturer, shipping, price, points, tax_class, date_available, weight, weight_class, Lenght, Width, Height,  length_Class, subtract, minimum, status. Note – enter yes in the add_product tab. Without yes in add_product column no new product import.

6. Links Links data tab content is  product_id, download, category, filter, related, store. Attribute This data tab content is  product_id, attribute, text

7. Recurring Recurring data tab content is product_id, recurring, customer_group. Discount This data tab content is product_discount_id, product_id, customer_group, quantity, priority, price, date_started, date_end.

8. Special Special data tab has product_special_id, product_id, customer_group, quantity, priority, price, date_started, date_end columns. Image Image data tab have product_image_id, product_id, image, sort_order columns.

9. Reward Points reward points data tab have product_id, customer_group, points columns. SEO  SEO data tab content product_id, store, keyword columns. Design Design data tab content product_id, store, layout columns.

10. Product Option The product Options tab has product_id, type, name, value, required columns. ProductOptionValue Product option value have product_id, option, option_value, quantity,price,points,weight, subtract, price_prefix,points_prefix, weight_prefix  columns.