OpenCart XLS Import (1.5.x , 2.x & 3.x,4.x)

SPECIAL FEATURE

EXPORT BY STORE, LANGUAGE, MANUFACTURER, ETC
EXPORT BY PRICE RANGE
EXPORT BY LIMIT (if your server have limited memory you can use this option its help a lot)


FILED LIST FOR IMPORT AND EXPORT LOT OF FEATURE PRESENTS

PRODUCT ID (if you are going to add a new product leave this empty and chose option upload by product id)
Language
Stores
Stores id (if you did not want put store name you can use id also multiple (0;1;2 etc))
MODEL (if you want unique by the model you can choose option upload by product model)
SKU UPC EAN JAN
ISBN MPN Location
Product Name
Meta Tag Description
Meta Tag Keywords
Description
Product Tags
Price
Quantity
Minimum
Quantity
Subtract
Stock (1=YES 0= NO)
Out Of Stock Status (5=Out Of Stock, 8=Pre-Order, In Stock=7, 6=2 - 3 Days)
Requires Shipping (1=YES 0= NO)
SEO Keyword (Must Unquie)
Image(Main image)
Date Available
Length Class (1=Centimeter, 3=Inch, 2=Millimeter)
Length
Width
height
Weight
Weight Class (1=Kilogram,2=Gram,6=Ounce,Pound=5)

Status (1=Enabled, 2= Disabled)
Sort Order
Manufacturer id
Manufacturer

Categories id
Categories (category>subcategory; category1>subcategory1; )

Related Product ID (you can use product id (find from url) (10;12;13))

Related Products (if you did not know the product id you can use the product model)

Option: (option1::value1-qty-Subtract Stock-Price-Points-Weight-sort_order)

Images (image1;image2;image3)

Product Special price:(customer_group_id:start date:end date: special price )

Tax Class (None=0, Taxable Goods=9, Downloadable Products=10) Rest you can make and put that ID

Filter Group Name (Group Name: Sort order; Group Name: Sort order)

Filter names (group name=name:sort order;group name=name:sort order)

Attributes (Attribute group name:sort order=attribute name-value-sort order;)

Discount (customer_group_id:qty:Priority:Price:Date Start:Date End;customer_group_id:qty:Priority:Price:Date Start:Date End;)

Reward Points

Viewed

Download Id

Review


Support
Any question suggestion is most welcome. If you have any kind of question, suggestion, or looking for support. Please create a ticket.