Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Import Products


Recommended Posts

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.

Link to comment
Share on other sites

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 ?

Link to comment
Share on other sites

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 ?

 

Link to comment
Share on other sites

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:

image.png.4c5047b09667f5fab7f88206849cf0e2.png

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.

Link to comment
Share on other sites

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:

image.thumb.png.c1eb16eb227b76477843575a806f7f88.png

OscLink.zip

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...