I have an eCommerce Drupal website with a large amount of products listed. One of my suppliers has 18,000 items and I get sent an updated file every day with updated pricing, stock quantities, new items and of course items that are no longer available are simply removed in the updated CSV file etc.
From this csv file I have to manually allocate items to categories that have been created on my website and therefore my pricing csv import file differs from the original file.
Is there a program that can compare the CSV or Excel files and where I can select which fields i.e. “stock number to compare and update with for example price and quantity on hand etc? and that can then generate a new file which I can simply import again?
Looking forward to your suggestions and advice.
Regards
Rudi
Comments
Can you not do this within
Can you not do this within excel with vlookup or pivot tables - add columns with formulae that do the comparison?
If you're happy to share partial extracts of these two files I can probably provide you with a solution.
You can also do the same in Google Sheets with the benefit of being able to use the script editor to write a custom solution, output it in the correct format and use the feeds module to regularly import it... for example.
The feeds module
Hi Rudi,
Have a look at https://www.drupal.org/project/feeds combined with https://www.drupal.org/project/feeds_tamper. I run two sites with the same requirements and it works like a dream.
Commerce
Sorry forgot the important one... https://www.drupal.org/project/commerce_feeds
Can all be done in Excel
Hi Rudi
I'm pretty sure what you're asking can be done easily in Excel before exporting / importing the data. Check out the 'data table' feature (I'm not sure exactly what it's called), which lets you short / filter all your data by particular columns.
Dane
Dane Rossenrode
Designer and Web Developer @ Touchdreams