|
Monday, 18 May 2009 09:22 |
|
Hi all excellent database experts!
1. I need to transfer my existing mysql Virtuemart database/ products
from specified categories to my new Magento setup.
2. Also, I need to import an XML-file into Magento.
3. I am wondering how I can get my CSV-file imported every day into magento, the existing SKU´s currently inside my virtuemart database should not be overwritten with those in the file, because I have inserted them manually with categorys and attributes. The things that I want to insert is new SKUS that appear in the CSV-file, and update all prices and stock every day, -or- many times a day :)
Right now, I do it like this in my Virtuemart-setup;
1. My internal program exports xxxx.vsn (the price CSV-file)
2. Another program (priceimport.exe) reads the file and inserts price and stock into the SKU´s in my virtuemart database every day at 18.30 (windows scehduling),
and it takes approx. 45 minutes... 65.000 SKUs. (!!)
This is done by
------------------------------------------------------------------
My Setup
VM 1.1.3 (live) -> Magento 1.3.1 (test/will get to be live) (Norwegian translation setup)
All passwords and usernames will be sent to the programmer :)
|
