Import Products

[dinozisharma]

In new oscommerce version products import stuck onto 985 records.

[pandrei]

10 hours ago, dinozisharma said:

In new oscommerce version products import stuck onto 985 records.

It looks like the PHP script was forced to terminate.

Check the Apache error log. Your hosting may have resource limits for PHP scripts.

[dinozisharma]

Hosting team have done all required updates.
I have imported customers around 424,854 and found no issue in import.

But products import not working, it stuck after 21,000 then I started import again than stuck at 23,504
If I am trying to delete all products so that I can try import again from scratch its deleting in split manner.

"Finished cleaning for Products! Entities found: 88930, deleted now: 835, deleted before: 88095, deleted related: 0, error: 0"

Is there any way to delete all products in one go and same for import ?
Or is there any solution I can import products in split manner (20,000) each ?

[dinozisharma]

And I have one more question in future when we want to upload the products,customers,orders of last 7 days  from old website then  we it will take same time ? (It will do update for all existing products,orders,customers) again ?

 

[pandrei]

7 hours ago, dinozisharma said:

Hosting team have done all required updates.
I have imported customers around 424,854 and found no issue in import.

But products import not working, it stuck after 21,000 then I started import again than stuck at 23,504

The customers do not have related images, but the products have...

I see that the script was terminated, and if you said that there was a successful long import before this, then most likely the script was terminated due to memory overflow.

Let me know the value of memory_limit PHP option like this:

Recommended value is 512M. During the import, you can increase it to 1024M and repeat the import. If the number of imported products doubles, then the problem is in some images, when importing them, memory leaks in PHP libraries accumulate.

A temporary solution is to increase the memory_limit option. Please keep us updated

7 hours ago, dinozisharma said:

Is there any way to delete all products in one go and same for import ?

You can delete only imported products into the Clean imported data tab.

You can delete all products and categories into Products/Catalogue->Import/Export->Data management

7 hours ago, dinozisharma said:

Or is there any solution I can import products in split manner (20,000) each ?

7 hours ago, dinozisharma said:

And I have one more question in future when we want to upload the products,customers,orders of last 7 days  from old website then  we it will take same time ? (It will do update for all existing products,orders,customers) again ?

Unfortunatelly, it will be possible only in the next version.

[dinozisharma]

[dinozisharma]

If I create duplicate database with limited data so that I can import data easily then where do I need to add those database details to make connection ?

[pandrei]

2 hours ago, dinozisharma said:

If I create duplicate database with limited data so that I can import data easily then where do I need to add those database details to make connection ?

Sorry, but this is not a good idea 🙂

You can replace all folder lib/common/extensions/OscLink with the OscLink folder in the attached zip file.

After that try to use this mode:

OscLink.zip

[dinozisharma]

Thanks for update
I will try this

[dinozisharma]

Folder Uploaded but showing error

[dinozisharma]

as per error log

[13-Jun-2024 03:31:33 Europe/London] PHP Fatal error:  require_once(): Failed opening required '/home/osc22furniturein/public_html/lib/common/extensions/OscLink/lib/autoload.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/osc22furniturein/public_html/lib/common/extensions/OscLink/OscLink.php on line 25
[13-Jun-2024 03:31:34 Europe/London] PHP Fatal error:  require_once(): Failed opening required '/home/osc22furniturein/public_html/lib/common/extensions/OscLink/lib/autoload.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/osc22furniturein/public_html/lib/common/extensions/OscLink/OscLink.php on line 25
[13-Jun-2024 03:31:38 Europe/London] PHP Fatal error:  require_once(): Failed opening required '/home/osc22furniturein/public_html/lib/common/extensions/OscLink/lib/autoload.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/osc22furniturein/public_html/lib/common/extensions/OscLink/OscLink.php on line 25
[13-Jun-2024 03:31:39 Europe/London] PHP Fatal error:  require_once(): Failed opening required '/home/osc22furniturein/public_html/lib/common/extensions/OscLink/lib/autoload.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/osc22furniturein/public_html/lib/common/extensions/OscLink/OscLink.php on line 25

 

[pandrei]

1. Check if  /home/osc22furniturein/public_html/lib/common/extensions/OscLink/lib/autoload.php file exists

2. Check the rights to this file

[dinozisharma]

[dinozisharma]

File Exists and permissions are also fine.
Please help in how to resolve this

[pandrei]

What about file group and file owner? Compare permissons and owner/group with other php file in other folder that was not changed.

[dinozisharma]

[pandrei]

It seems ok with owner and permissions.

On 6/14/2024 at 5:36 AM, dinozisharma said:

The autoload.php file into the attached archive has a size of 816 bytes. Why is your file a different size 791?

Also I see the different sizes in other files:

Helper.php 2312 -> 2335

Logger.php 2192 -> 2017

Progress.php 3178 -> 3081

Edited June 17, 2024 by pandrei

[dinozisharma]

• 

[dinozisharma]

Files are of same size but still not working

[pandrei]

But now they have a different permissions. Also you have to give write permission for tmp and log folders inside OscLink directory

[dinozisharma]

Now permissions 777 but still not working

[pandrei]

4 hours ago, dinozisharma said:

Now permissions 777 but still not working

Could you send me the log files in PM? (Admin->Settings->Tools->Error log viewer->Download all logs)

[dinozisharma]

logs_44_1718783315.zip

[pandrei]

Thanks. Copy the attached file to lib/common/helpers/ArrayHelperEx.php

ArrayHelperEx.php

[dinozisharma]

yes uploaded this file and error fixed
Thanks a lot !
But its not working as expected like when I tried to make connection showing

: Error while establishing connection: Assertion: string(common\helpers\Status) has not method string(isComplitedGroup)

Also
in Mapping settings