BarikLabs 6 years ago

This is quite handy extension.
But there is small bug on it:

The right value for column status in product is yes/no.
But if we export the product data >> status value is true/false

JNeuhoff 6 years ago

Not a bug, both 'yes' and 'no', or 'true' and 'false' will work. In the database it's always '1' or '0'.

fatih93 6 years ago

Hello,
What are the restrictions in the free version?
Is there a pro version?

JNeuhoff 6 years ago

There are no restrictions, it's all published under the GPL V3 license., see http://www.gnu.org/licenses/gpl.html

JNeuhoff 6 years ago

Some people simply don't get it: This comment section is not for technical support, use the 'Get Support' link or the OpenCart forum for support! And read the FAQ page!

dimitris212 6 years ago

It is perfect module!
Is it possible sales import / emport?

neesan 6 years ago

Thank you very much.

spake 6 years ago

When i want to export Products i have this error:

PHP Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 524288 bytes) in /home/example/public_html/system/library/export_import/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 177

Dean1986 6 years ago

your using shared or low powered hosting... problem is your server pal.

"Requirements and Limitations
Memory requirements can be quite high.

Not every shared web hosting account supports a high process memory usage. Therefore, if you use a basic shared web hosting account, no more than a few thousand products can be exported or imported at a time. Use a more dedicated web hosting account if a higher number of products are to be processed in one go. Or export and import multiple times in smaller batches."

BuslikDrev 6 years ago

Логика написания этого модуля плохая. Каждый раз когда вы получаете имя листа идёт перебор всех данных.
$reader->getSheetByName( 'Categories' );

public function getSheetByName($pName = '')
{
$worksheetCount = count($this->workSheetCollection);
for ($i = 0; $i < $worksheetCount; ++$i) {
if ($this->workSheetCollection[$i]->getTitle() === $pName) {
return $this->workSheetCollection[$i];
}
}

return null;
}

Рекомендую переделать так, чтобы загружало 1 раз все вкладки и условием уже определяли в какую таблицу записывать данные.

JNeuhoff 6 years ago

I know its hard for some to understand:

This comments section is not for technical support enquiries. Please read the proper documentation and FAQ page (see top of this page), or use the 'Get Support' button!

BertR 6 years ago

Ok sorry
Remove my comment above

nikoslefkas 6 years ago

Hi there!
I am trying to use your extension to export categories and products from an Opencart 2.0.0.0 and import them in an other Opencart version 3.0.3.2.

So, when I'm trying to import the files I am getting an error.
The error logs are those:
2020-03-25 12:31:01 - Export/Import: Invalid header in the Categories worksheet
2020-03-25 12:31:01 - Export/Import: Invalid header in the CategoryFilters worksheet
2020-03-25 12:33:22 - Export/Import: Invalid header in the Products worksheet
2020-03-25 12:33:22 - Export/Import: Invalid header in the ProductOptions worksheet
2020-03-25 12:33:22 - Export/Import: Invalid header in the ProductOptionValues worksheet
2020-03-25 12:33:22 - Export/Import: Invalid header in the ProductAttributes worksheet
2020-03-25 12:33:22 - Export/Import: Invalid header in the ProductFilters worksheet

Can you help me please to solve this problem ?
Thank you in advance!
Nikos

INSOF2014 6 years ago

i cant export products i hace an error

Undefined offset: 6

I have the version 3.0.3.2

sirkamau 6 years ago

Did you get a solution for this error?

shakalby 6 years ago

всем привет, товары без фото как исправить?

Sanjeev8 6 years ago

Able to export all options available except customer data. When I hit export button, then it takes some time to begin download and then an excel file 0 bytes is saved on my system. When I open it then it MS excel ask me to check if the file is not corrupt.

Grishazahid 6 years ago

Step 6)
Set access and modify permissions for 'tool/export_import'
this permission does not appeared . Version 2.3.0.2. Tried to install via Extensions > Installer > Upload

noltupiyde 6 years ago

Hello. I'm using opencart 1.5.6.4 and can't find this tool in admin panel. I copied folders from .zip file (admin,system,vqmod) to my main folder /www/,
which contains all opencart folders. What i'm doing wrong?

xxvirusxx 6 years ago

You have Vqmod installer?

noltupiyde 6 years ago

I have Vqmod folder

noltupiyde 6 years ago

Any ideas to help resolve this issue?

Vincentmou 6 years ago

Hello，
After i install the Export/Import Tool, where i can download the xlsx form template for uploading products?

2177733 6 years ago

Здравствуйте! при попытке импортировать файл пишет:
Uploaded spreadsheet file has validation errors!
See also the System > Maintenance > Error Logs for more details.
No server data has been changed.

caraban2 6 years ago

Una muy Buena herramienta, si todo en OpenCart funcionara igual, seria la mejor del mundo !!

ilkr 6 years ago

Category export not work on 3.0.3.2. Give an error "Trying to access array offset on value of type int".

YD 6 years ago

I encountered a similar issue. Resolved it by downgrading from PHP 7.4 to 7.2.

Tesla-Direct 6 years ago

I've sent 2 emails and opened 1 support ticket over the last 3 mouths to get a custom made Export/Import Tool the first ticket i opened was on November 27, 2019 at 08:11 GMT Time they never replied to any of my messages why advertise under Export/Import Tool saying If you need a customized version, let us know and we can create one for a charge. if you never intend to reply to your customers.

koskyh 6 years ago

Caution! Version opencart-2-x-export-import-multilingual-3-22.ocmod there is a virus

JNeuhoff 6 years ago

Stop spreading false rumors here. All files are plain PHP open source. There are hundreds of thousand users who use this tool successfully.