Updating Pricelists

[Stephan (VS)]

What method(s) do you prefer to use to update your pricelists?

 

I usualy use export to excel -> Edit manualy -> Import back and viola, nice and easy.

 

The problem is this is becoming mmore and more work since we now use suppliers who constantly change +- a 100 of their product codes for optomizations.

 

I was wandering if there is a faster way or some software that can

 

1. (if given the codes (in two excel columns) that have changed) compare & replace the old product codes with the new ones &

2. Compare the old prices with the new ones and do the updates.

 

What methods do you prefer to use to update your prices every time a supplier hands out the new pricelyst? :huh:

[FIMBLE]

Not sure if its any use to you, there is a contribution that allows you to update multiple amounts of prices at once.

Try a search if the contributions for it.

[Guest]

Like this one:

 

 

 

http://addons.oscommerce.com/info/122

 

 

Chris

[Stephan (VS)]

THanks for the replies, :D

 

I looked at the contributions but,

 

I decided to write some complex functions in excel that could do the job.

[♥bruyndoncx]

My process is usually based upon Easy Populate. I've modified my version to allow selection by manufacturer, so I can do a partial export.

I've also used an opensource ETL tool (kettle) in the past to generate EasyPopulate files to update the system but it relied on a database connection from my desktop to the mysql database on the site. I had to revert back to Easy Populate as the host only exceptionally allowed this kind of access. Currently I have a VPS sytem with straight db access, but I still tend to rely on Easy Populate as it is pretty easy.

 

My steps:

1. get file from supplier and put it in xls

2. export (subset) using Easy Populate.

3. move EP export file (tab separated) into another excel sheet in the suppliers xls

4. define the range with the suppliers prices as a named range 'plist' (ensure it is sorted alphabetically)

5. add a new column in your EP export to hold a vertical lookup vlookup (vertical search / vert.zoeken) function to find the new price

something like:

=vlookup(A2;plist;5;false)

6. add another column to compare the new price to the existing price and apply filter to just keep the changed records

7. SAVE

8. copy filtered results to new sheet and save as txt file to allow for EP upload

9. upload in EP

 

HTH