Dan
Premium Member
Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
|
I have a .csv feed from a supplier, which is updated daily.
The way its laid out, is completely different to the one magento (the store i use) uses.
The description is just plain text, but needs to be in a html format ideally.
Ive heard there are ways to convert it onsite, and upload it using cron jobs etc.
Its way over my head. Is this possible and whats in gonna cost.
Also, it really needs to be magento upgradable (needs to follow magento's protocol.
Manual upload is really out of the equation as there are around 3700 items.
Opinions?
Dan
Adult GiftsClick here to vist us
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
What about if you were to manually upload the file to your server and have a PHP script access the file contents, split into products and insert into your store database?
Should work, though I've no idea on this magneto thing so not promising!
|
Dan
Premium Member
Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
|
Magento already has a great importing feature, which you can import data very easily.
Its the problem that the data is all over the place in the .csv they supply, different headings and the descriptions are in a normal text format, rather than a html one.
Adult GiftsClick here to vist us
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
U2U'd
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
What is it you actually want? A php script (small desktop app?) to import the .csv from a directory and spit a magento .csv file? Or do you want to import the .csv, format it correctly and either add the new products to the database or call the magento import function/class perhaps?
If you've got an example of the .csv file (only need a few lines) and how you want it formatted (example of a magento .csv perhaps?), then send it over and i'll have a butchers 
|
ashleh
Member
Registered: 23rd Dec 08
Location: Nottingham
User status: Offline
|
Couldn't you create a batch or perl script and run it locally then upload/import to your script?
Or as you mentioned run a cron job, there should be plenty of tutorials
|
