Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Dear all,

we are currently trying to come closer a working environment for our needs using oscommerce 4. There is a need for us to import products from an external source so items aren't put in manually.

To achieve this a php file is used that has to fulfil these 4 purposes.

1. Push data to the products database (OK)
2. store picture file in ep_files/manual_import/images/ folder (OK)
3. replace the CSV file on the manual import that is preset in backend (OK)
4. Initiate the import process for that csv file (not ok at all)

I'm aware this is the worst step we have to try to complete. Right now we'd use the php for steps 1-3 and manually pushing the import on the backend which is okayish but it would be great to find a way to import using the very same procedure so it's all automatical.

Maybe someone has an idea how to get closer to getting this to work. I've looked around a lot so far but couldn't figure it out. Maybe someone here has a good understanding of the import process and can help us out.

Cheers
Florian

Screenshot 2023-06-14 at 14.25.05.png

Posted
On 6/14/2023 at 3:31 PM, DrFlo said:

Dear all,

we are currently trying to come closer a working environment for our needs using oscommerce 4. There is a need for us to import products from an external source so items aren't put in manually.

To achieve this a php file is used that has to fulfil these 4 purposes.

1. Push data to the products database (OK)
2. store picture file in ep_files/manual_import/images/ folder (OK)
3. replace the CSV file on the manual import that is preset in backend (OK)
4. Initiate the import process for that csv file (not ok at all)

I'm aware this is the worst step we have to try to complete. Right now we'd use the php for steps 1-3 and manually pushing the import on the backend which is okayish but it would be great to find a way to import using the very same procedure so it's all automatical.

Maybe someone has an idea how to get closer to getting this to work. I've looked around a lot so far but couldn't figure it out. Maybe someone here has a good understanding of the import process and can help us out.

Cheers
Florian

Screenshot 2023-06-14 at 14.25.05.png

Hi Florian,

Please see the article (comments above the first 2 screenshots) - https://www.oscommerce.com/wiki/Managing_Automatic_Import_and_Data_Sources

Please upload your file to the folder ep_files/auto_import/ (and for images upload it to ep_files/auto_import/images/ correspondingly) on the server.

After you set up events/import on the cron the system detects if your file has been changed. If it has been changed the system runs the import process. Please see the screenshot below with the cron settings as a sample. In this way you can replace files once a day and they will be processed.

Best regards,

Ivan

image.png.655251ca2345d4d1acba93e394f1b98a.png 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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...