[RELEASED] Product Import Export - Bulk Insert Update Export

Product Import Export v1.0 Compatibility

OpenCart v1.5.1.3.1
OpenCart v1.5.1.2
OpenCart v1.5.1.1
OpenCart v1.5.1
OpenCart v1.5.0.5
OpenCart v1.5.0.4
OpenCart v1.5.0.3
OpenCart v1.5.0.2
OpenCart v1.5.0.1
OpenCart v1.5.0
--------------------------------
Back office Demo: http://www.backonoc.com/demo/oc1.5.1.2/admin
demo/demo

Supports vqmod!
Extension can be purchase here http://www.opencart.com/index.php?route ... on_id=3971
Get cheaper on backonoc

Pay attention - Product Attribute , Product Option , Product Discount , Product Special information can not import or export!

Bulk import export product, detail as follows : download and see the excel format here http://www.backonoc.com/demo/oc1.5.1.2/ ... insert.xls.

Product Name
Meta Tag Description
Meta Tag Keywords
Description
Product Tags(just type the tags name,seperated with ",")eg:tag1,tag2,tag3
Model(we use this field as Primary Key to bulk insert/update product.If model exists,can NOT insert product but can update)
Price
Tax Class
Quantity
Minimum Quantity
Subtract Stock
Out Of Stock Status
Requires Shipping
SKU
UPC
Location
SEO Keyword
Image(type server image path here,like data/apple_logo.jpg) Case-insensitive: data/apple_logo.jpg and DATA/APPLE__LOGO.JPG are different!
Dimensions (L x W x H) seperated with "," eg 1,2,3 means 1 x 2 x 3
Length Class
Weight
Weight Class
Status
Sort Order
Manufacturer
Categories(just type the category name,seperated with ",")eg:apple,imac,iphone
Stores
Related Products(If product model do NOT exists,then can not insert related products.If exist,can insert/update related products)
AdditionalImage
Points
Product Reward(seperated with ",") eg:Wholesale=0,Default=0

-------------------------------------------------------------------------------------------------
Very important! --- How to use Product Import Export
Product import export extension is powerful enough to help you manage hundreds of products.Once you know how it works, it is very easy to use. Now I am using the original opencart product as example.

First, install product import export extension, give user permissions to "catalog/productimportexport", back to productimportexport.Select product , then click "export selected", download and save the excel files,let's call it "download_products.xls".Okay, here we go.

Bulk Insert Product - Delete the selectd product just export,and click "import product",select the excel file "download_products.xls" just export and select "insert",you will see that the selectd product just deleted forever from mysql back to opencart.
Bulk Update Product - Open the excel file "download_products.xls" just export, make some changes each field(except Model,do NOT change the Model),leave the field blank or still the same if you don't want to update this field, click "import product",select the excel file "download_products.xls" just changed and select "update",you will see that products that you changed had been updated.
-------------------------------------------------------------------------------------------------

support : yuyamu@hotmail.com

If you could now explain why your tool is so much better than the free tool of JNeuhoff I would be more satisfied.
The more you are only handling products ...

OSWorX wrote:If you could now explain why your tool is so much better than the free tool of JNeuhoff I would be more satisfied.
The more you are only handling products ...

There is a demo,you try it.
The free tool of JNeuhoff is not easy to do the manage product work.
Too many sheet in the excel.

We only have one sheet.

But this extension must can not be met anyone's need.Like product with lots of options or attributes.
It is your choice to use it or not,according to your products.

Hi

Looks like a nice extension. Just bought it and i have a small problem and couple of questions.

1- I have already VQMod and using it with another extension.

2- Uploaded those to my server:
admin\controller\catalog\productimportexport.php
admin\language\english\catalog\productimportexport.php
admin\model\catalog\productimportexport.php
admin\view\template\catalog\productimportexport_bulk.tpl
admin\view\template\catalog\productimportexport_form.tpl
admin\view\template\catalog\productimportexport_list.tpl
upload product-import-export.xml to vqmod/xml folder

3- (Question) There is no explanations for system/Pear and system/PHPExcel folders? I already uploaded them but i did not see anything for them. Do i need to upload or not?

4- Permissions done:
Access permission:select "catalog/productimportexport"
Modify Permission:select "catalog/productimportexport"

5- (Problem) When i go to admin/catalog/Product Import Export tab i see that error:

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
SELECT COUNT(*) AS total FROM oc_product p LEFT JOIN (SELECT * FROM oc_product_description WHERE language_id = '1') pd ON (p.product_id = pd.product_id) WHERE 1

----

What is the solution?

Thanks for your help.

Kind Regards

PS: I am going to share this problem on comments section of extension aswell (and will email you) so if people live same problem they might see answer and sort it out without asking you.

turantekin wrote:Hi

Looks like a nice extension. Just bought it and i have a small problem and couple of questions.

1- I have already VQMod and using it with another extension.

2- Uploaded those to my server:
admin\controller\catalog\productimportexport.php
admin\language\english\catalog\productimportexport.php
admin\model\catalog\productimportexport.php
admin\view\template\catalog\productimportexport_bulk.tpl
admin\view\template\catalog\productimportexport_form.tpl
admin\view\template\catalog\productimportexport_list.tpl
upload product-import-export.xml to vqmod/xml folder

3- (Question) There is no explanations for system/Pear and system/PHPExcel folders? I already uploaded them but i did not see anything for them. Do i need to upload or not?

4- Permissions done:
Access permission:select "catalog/productimportexport"
Modify Permission:select "catalog/productimportexport"

5- (Problem) When i go to admin/catalog/Product Import Export tab i see that error:

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
SELECT COUNT(*) AS total FROM oc_product p LEFT JOIN (SELECT * FROM oc_product_description WHERE language_id = '1') pd ON (p.product_id = pd.product_id) WHERE 1

----

What is the solution?

Thanks for your help.

Kind Regards

PS: I am going to share this problem on comments section of extension aswell (and will email you) so if people live same problem they might see answer and sort it out without asking you.

I might miss the upload system folder parts.Yes,it need to upload to the server too.

This is the first time we see this error.
Please create a demo admin account and ftp account for me.
I will check it for you later.

Bingo

Hi

Thanks for quick reply. Please check your email for details.

Already sent it.

Thanks

Uygar

when trying to search products to export it is telling me theres x amount of pages but products are not showing. this is only when searching by name

mosesg wrote:when trying to search products to export it is telling me theres x amount of pages but products are not showing. this is only when searching by name

So,only search by name can not work?
search by model can work?

Bingo

Hi Just purchased and have an issue.

Everything seemed to go fine for installation.

When I do import it says successful BUT no new products are showing up! or no changes are showing.

Not sure what the problem is but PLEASE help.

Figured it out...

I had to be sure the MODEL name was different for all. I just read above the this is a major requirement.

Once this was figured out. I must say the extension is spot on! very very easy to use.

Just one question though is there a way it could auto add a catagory or manufacturer if it doesn't already exist.

jpadvertiing wrote:Figured it out...

I had to be sure the MODEL name was different for all. I just read above the this is a major requirement.

Once this was figured out. I must say the extension is spot on! very very easy to use.

Just one question though is there a way it could auto add a catagory or manufacturer if it doesn't already exist.

Hi,can not auto add a catagory or manufacturer if it doesn't already exist.

bingo wrote:

turantekin wrote:Hi

Looks like a nice extension. Just bought it and i have a small problem and couple of questions.

1- I have already VQMod and using it with another extension.

2- Uploaded those to my server:
admin\controller\catalog\productimportexport.php
admin\language\english\catalog\productimportexport.php
admin\model\catalog\productimportexport.php
admin\view\template\catalog\productimportexport_bulk.tpl
admin\view\template\catalog\productimportexport_form.tpl
admin\view\template\catalog\productimportexport_list.tpl
upload product-import-export.xml to vqmod/xml folder

3- (Question) There is no explanations for system/Pear and system/PHPExcel folders? I already uploaded them but i did not see anything for them. Do i need to upload or not?

4- Permissions done:
Access permission:select "catalog/productimportexport"
Modify Permission:select "catalog/productimportexport"

5- (Problem) When i go to admin/catalog/Product Import Export tab i see that error:

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
SELECT COUNT(*) AS total FROM oc_product p LEFT JOIN (SELECT * FROM oc_product_description WHERE language_id = '1') pd ON (p.product_id = pd.product_id) WHERE 1

----

What is the solution?

Thanks for your help.

Kind Regards

PS: I am going to share this problem on comments section of extension aswell (and will email you) so if people live same problem they might see answer and sort it out without asking you.

I might miss the upload system folder parts.Yes,it need to upload to the server too.

This is the first time we see this error.
Please create a demo admin account and ftp account for me.
I will check it for you later.

Bingo

Did you guys figure out the solution I am getting the same error?

After the installation I get the following erro .. Please help


Fatal error: Cannot access private property Document::$title in /home/sms/public_html/new/admin/controller/catalog/productimportexport.php on line 8

HI Since I have installed this it is working but it has caused the error to stop the options and attributes to not function in the admin panel.

I would really like to know why this has happened.

bsm05 wrote:After the installation I get the following erro .. Please help


Fatal error: Cannot access private property Document::$title in /home/sms/public_html/new/admin/controller/catalog/productimportexport.php on line 8

create a ftp account and demo admin account for me.
Send to my email:
yuyamu@hotmail.com

also in the email,please attach your order id and email.

bingo

jpadvertiing wrote:HI Since I have installed this it is working but it has caused the error to stop the options and attributes to not function in the admin panel.

I would really like to know why this has happened.

This extension had nothing to do with product options and attributes.

I wanted to know what all formats this tool supports other than excel, Does it support csv?

romit wrote:I wanted to know what all formats this tool supports other than excel, Does it support csv?

only excel.
You can save as csv after you export to excel.

bingo

I installed the free export/import tool by jneuhoff(http://www.opencart.com/index.php?route ... e=JNeuhoff), and first exported my default catalog to excel and then made some text changes in that and then tried to import the same excel. It gave following error:-
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

Can anybody help me on this?

hello,
i checked the demo page and I have one question. Is it possible to select the products I want to export(and update) by manufacturer or product category??
I've already installed another extension ( http://www.opencart.com/index.php?route ... order=DESC) which gives me this option but I don't know if it will work probebly in combination...
can you please take a look and let me know??

thanks a lot in advance!