We have a file supplied in csv format from out supplier with details of stock quantity and price. The next day we get another file, with new stock quantities and new prices. What we want to do is the new file compares to the old file, updates prices and also items in stock, add new products to the list and remove any products that are out of stock. Also we require a simple conversion, that allows to arrange the correct pricing, the pricing on the file is the cost price (the price we buy the item at), we want this to convert to our sale price. So an extra box could be added with our sale price. So this would be cost price, plus postage, VAT and then our percentage
The file must then be converted back to csv file (if it has been changed) so we can upload to our website. The layout of the csv file is similar to
Code Title Manufacture Quanity Price
If you can create some kind of macro, or something similar that will work better, please provide a bid on this for us.
I forgot to mention that the csv files have in excess of 100,000 lines of data, (1 for each product) the macro needs to be able to process this data in a sensible amount of time.