Tabs of Excel Sheet used with Bulk Export and Import Extension

If you want to add more products to your Opencart store then Product Bulk Export and Import Extension is for you. Product Bulk Export and Import extension developed by Purpletree Software. Product bulk Export and Import extension used to export and Import product by using excel interface. You can also update any information related product using Product Bulk Export and Import Extension.

Opencart import/export extension provides the facility to add and update products in all available store language. Opencart import products with excel sheet, This Extension provides 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 can export all products and change product information in an excel sheet and checked Overwrite existing Data after that import the sheet.

1 blog

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 the 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.

We will discuss various tabs of Excel Sheet used with Bulk Export and Import Extension in this blog.

General  

This tab contains general data related to product like product_id, name, description, tag, meta_title, meta_description, meta_keyword.

2 blog

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.

3 buk

Links

Links data tab content is  product_id, download, category, filter, related, store.

4 bulk

 

Attribute

This data tab content is  product_id, attribute, text

5 bulk

Recurring

Recurring data tab content is product_id, recurring, customer_group.

6 bulk

Discount

This data tab content is product_discount_id, product_id, customer_group, quantity, priority, price, date_started, date_end.

7 bulk

 

Special

Special data tab has product_special_id, product_id, customer_group, quantity, priority, price, date_started, date_end columns.

8 bulk

Image

Image data tab have product_image_id, product_id, image, sort_order columns.

i bulk

reward points

reward points data tab have product_id, customer_group, points columns.

10 image

SEO

 SEO data tab content product_id, store, keyword columns.

11 bulk11 bulk

Design

Design data tab content product_id, store, layout columns.

12 bulk

Product Option

The product Options tab has product_id, type, name, value, required columns.

13 bulk

ProductOptionValue

Product option value have product_id, option, option_value, quantity,price,points,weight, subtract, price_prefix,points_prefix, weight_prefix  columns.

14 bulk