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.

3
(No Transcript)
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.
11
(No Transcript)