Magento Change Quantities Question
I am wondering if anyone has experience with bulk changing quantities in Magento, and if anyone has found a better way to do this than I have.
Here is how I am currently accomplishing this:
Im using Python as my main program. I use SQL statements to pull quantities from our POS database and put that data into a CSV file. I then access a PHP file on my Magento server which creates a CSV file of all the parts and their quantities. I FTP that file down to the same folder as the CSV of our POS system quantities. Then I go through each CSV and get the absolute value of the quantities fields that have changed. I then make another CSV and FTP it back into the server. Call another PHP that changes Magento's quantities of that of the CSV. Then I use SQL insert statements to change the POS database quantities.
This is all done via task scheduler and so far it works great. The only problem when I ran tests is that if we are changing over 200 part's prices than the script will not execute fully. I do not want to raise my time limit or memory limit on php. This right now is not a big problem because we are not selling 200 parts per minute.
Just wondering if anyone out there is doing things similar or completely different. I can post code for the various step if anyone wants them.
Here is how I am currently accomplishing this:
Im using Python as my main program. I use SQL statements to pull quantities from our POS database and put that data into a CSV file. I then access a PHP file on my Magento server which creates a CSV file of all the parts and their quantities. I FTP that file down to the same folder as the CSV of our POS system quantities. Then I go through each CSV and get the absolute value of the quantities fields that have changed. I then make another CSV and FTP it back into the server. Call another PHP that changes Magento's quantities of that of the CSV. Then I use SQL insert statements to change the POS database quantities.
This is all done via task scheduler and so far it works great. The only problem when I ran tests is that if we are changing over 200 part's prices than the script will not execute fully. I do not want to raise my time limit or memory limit on php. This right now is not a big problem because we are not selling 200 parts per minute.
Just wondering if anyone out there is doing things similar or completely different. I can post code for the various step if anyone wants them.