DrFlo Posted June 14, 2023 Posted June 14, 2023 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 Quote
Ivan Holbi Posted June 16, 2023 Posted June 16, 2023 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 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 Quote
Recommended Posts
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.