srtglobal 7 years ago

when i upload something it cancel the images which i choosed as rotator image yes to no ..please fix it.

DJD1 7 years ago

Hello. On export, can you also export product images along with descriptions and price? How can you do this? I basically want to export by category .. eg "karaoke discs" and have separate files for each category. But.. I would like fields - Product name, description, image, price, stock. Is this possible?

TradingPostLLCMarion 7 years ago

Hello, this looks like exactly what I need! Will this work for the eMarket theme? I think it would since it has little to do with front end, but thought I'd ask! Thanks in advance!!

neolineinfo 7 years ago

Hi

We are also wondering the same, i.e. if this work for eMarket theme. Did you get a chance to try this?

Fred Wilkins 7 years ago

Anyone having problems saving the .xlsx, then uploading and getting error "Export/Import: Missing category_ids in worksheet 'Categories'!" I have found out why this happens and how to make it work perfect. The author recommends downloading "LibreOffice" which is not necessary at all.

siffrock 7 years ago

Hi,
would you be so kind to share how did you solve this problem?
Thanks

Fred Wilkins 7 years ago

@JNeuhoff - how to add a the "url keyword" field to the categories .xlsx? I tried to crete a new field in
column Q to add like this: "url_keyword(en-gb)" but no luck, getting the error "Export/Import: Invalid header in the Categories worksheet". How can I successfully add this field to categories worksheet?

Fred Wilkins 7 years ago

never mind, I found it in the "tab' section on the bottom of the xlsx! This is great!

adamkowalski333 7 years ago

I have a problem with these .xlsx files
2019-03-06 13:33:38 - Export/Import: Invalid header in the Categories worksheet
2019-03-06 13:33:38 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/mywebsite_root_folder/upload/system/library/template/Twig/Autoloader.php on line 12 ...............................

Fred Wilkins 7 years ago

you will get that error when you have changed, added or moved one of the 'grey' boxes on the top column. Best to re-download the categories xlsx file and restart.

Rs Comp 7 years ago

Por favor podrían indicar cual es el archivo cargar
gracias

magsilver 7 years ago

A good module, I use it since its release, was previously similar for 1.5 stores ..
Thanks to the developer!

Есть одна проблема - при постоянном обновлении товаров, меняется ИД товара, а так как на странице Продукты нет поля "Дополнительные изображения" на основном листе Products (они находятся на второй странице AdditionaliImages ) , то дополнительные изображения "слетают" и устанавливаются к другому товару. При небольшом количестве товара , есть возможность править, но когда количество товара превышает 4000 наименования- это становится проблемой. По итогу модуль не дает прав установить Доп.Изоражения для большого магазина.
К сожалению разработчик не обратил внимания на эту просьбу на форуме , или на захотел..Но было бы не плохо, если бы поправил и перенес доп.изображения на основной лист .
В остальном - прекрасный модуль.

magsilver 7 years ago

A simple solution in your situation is to manually add 1-2 categories of 1-2 goods to the store, set the necessary product data in the fields, then export. You will have sample files with columns and fields for further mass import. I hope I explained it clearly. Good luck.

Shihabudheenac 7 years ago

HI,
I installed your extension.
but I can't import products.
please give me a sample file for product import.

Thank you.

Curie 7 years ago

Hello!
Add one product in the admin panel, make the export of this product - this file will be a model for you to import.

sistemas@jako.com.mx 7 years ago

They are compatible with the extension: Options combinations - Chained options ??

neorama 7 years ago

can you make this for exporting orders too. please?

acheiprimeiro 7 years ago

Work Perfect on opencart 3.0.3.1 . Thank you.

Rs Comp 7 years ago

Hola
que archivo exportastes ?

nico1970 7 years ago

Hello, the module always worked fine but now i get this error message when i hit the export button.

No se puede acceder a este sitio web Es posible que la página web (Unable to access this website It is possible that the website) https://www.superstarspain.com/admin/index.php?route=tool/export_import/download&token=dYlYli0tuKiDOJgAevjd5A65IkSdQYMV esté temporalmente inactiva o que se haya trasladado definitivamente a otra dirección.(is temporarily inactive or has definitely moved to another address.)
ERR_INVALID_RESPONSE

Anybody an idea what it is???

FlipC 7 years ago

Link goes to your admin for me. Website seems to be working fine. (you need diff theme)
Beyond that a DNS issue/hiccup.
If it happens again use your IP instead of domain name to test.
If works - DNS error. Contact your domain registrar or your server provider -whom ever controls your DNS registration. If they are all good - then your ISP. Though the ISP wont probably.

doviis 7 years ago

Hello,
Where is the problem?

2019-02-14 15:27:33 - PHP Exception: Error: Duplicate entry '61-98' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `q0qy_product_to_category` (`product_id`,`category_id`) VALUES
(61,98),
(61,98),
(61,25),

FlipC 7 years ago

It tells you right there
Duplicate entry '61-98'
You have that twice - as you listed. Just deleted one of those rows.

shashwat.devbrat 7 years ago

I created a new Opencart with version 2.1.0.1 and my previous Opencart is 1.5.1.3
I installed your extension on both the sites. Exported products from 1.5.1.3 and imported into version 2.1.0.1 and it shows below error. Need help.
2019-02-12 9:45:53 - Export/Import: Invalid header in the Categories worksheet
2019-02-12 9:45:53 - Export/Import: Invalid header in the Products worksheet
2019-02-12 9:45:53 - Export/Import: Invalid header in the Specials worksheet
2019-02-12 9:45:53 - Export/Import: Invalid header in the Discounts worksheet
2019-02-12 9:45:53 - Export/Import: Invalid header in the Options worksheet
2019-02-12 9:45:53 - Export/Import: Invalid header in the Attributes worksheet
2019-02-12 9:45:53 - Export/Import: Missing AttributeGroups worksheet, or AttributeGroups worksheet not listed before Attributes
2019-02-12 9:45:53 - Export/Import: OptionValues worksheet also expected after an Options worksheet

FlipC 7 years ago

Dont use either version BUT - the versions probably have different headings.
If this was the case and you used the 1.5.1.3 EXPORT file to IMPORT directly into the 2.1 version. It would give you such errors. So I would suggest exporting the DEMO products from 2.1. Then clean that file of data (except headers) and manually transfer the data into correct headers. Save and retest import.

nikunj1993 7 years ago

For opencart 3.x
Those who didn't get link in maintenance tab, make following code changes

admin/language/en-gb/common/column_left.php add following line at the end of the file
$_['text_export_import'] = 'Export / Import';

admin/controller/common/column_left.php Line 592 add following code
if ($this->user->hasPermission('access', 'extension/export_import')) {
$maintenance[] = array(
'name' => $this->language->get('text_export_import'),
'href' => $this->url->link('extension/export_import', 'user_token=' . $this->session->data['user_token'], true),
'children' => array()
);
}

oceanografica 7 years ago

Works perfect now, thank you

S@nd3r 7 years ago

Hello, I used the opencart-2-x-export-import-multilingual-3-20.ocmod.zip version, but I miss to colums, purchase price and supplier, and now al my old purchase prices are reset to 0.... Is there a sollution for this? Thanks,

Sundayyang 7 years ago

I have successfully installed by FTP and I will list the problems encountered during the installation process for your reference.

1.Can't find under the menu System > Maintenance > Export / Import (for OC 3.x or later)

Find the install.xml on installation package file and follow the instructions to modify the two files (admin/controller/common/column_left.php and admin/language/*/common/column_left.php) by FTP.

2.PHP Fatal Error: Uncaught Error: Class 'ZipArchive' not found

This is caused by your PHP installation, if you are on linux server you need to add zip archive module in php version (For example on Godaddy: cpanel -> Select PHP version -> check zip module in this page).

alexalindayu 7 years ago

i follow all instruction but in my Version 3.0.3.1 opencart i cant find export/import under system > maintenance

alexalindayu 7 years ago

i miss one i got it thanks