Daily Imports

[bloom]

I get delimited text files every morning containing all of our product info including stock levels and new items. I can manipulate these files however I need to.

 

I am currently looking to switch our store to osCommerce from an .asp solution and the 1 remaining key question is this:

 

Is there a contribution that will allow me to upload my delimited file (txt or excel or whatever, it doesn't matter) DAILY and simply REPLACE the information in the fields. Example...I want to upload a delimited file that only has SKU, PRICE and PROD_STOCK (number of items we have in the warehouse) fields and have it update PROD_STOCK and PRICE for each given SKU. Best case scenario, I could feed it a file with a lot of fields, some empty, and have it only update the fields with contents.

 

It would also need to be able to automatically create a product in the cart if the file contained a sku not currently in the database.

 

Maybe I'm asking too much but is something like this already in existance? I know Miva's import function performs similarly.

 

Thanks!

 

(UGH...categories just occured to me. I can add category ID's to the file if I have to...)

[Guest]

you can use easypopulate, however it requires categories. if you want to use sku's you need to add that field to products, and then add it to easypopulate.

and easypopulate will do the other things you request.

[bloom]

Wow John you're just everywhere!

 

Thanks for the reply. I had been digging through contributions for 2 days but wasn't 100% sure that any would perform the way I needed them to.

 

I'll take a test run at EasyPopulate. Thanks again.

[Guest]

if you write a script via vb, something like that, you can automate the changes and then upload the file