We have two csv files examples attached "[url removed, login to view]" and [url removed, login to view]", containing product information and cost price data. We collect these files by CSV and would like the following to happen to the data in these files.
1.) The data from the above files needs to populate the [url removed, login to view] file. The collumn headings need to be remapped as per supplierFileLayoutsMapped+%281%29.xls. (The collumns on the Products_Joined file, entitled: "Autodropship" & "Allowbackorders" need to all contain a value of "Y".
I have supplied a copy of our old "macrofile" which was used in a similar way, with a discontinued data file. The Macrofile does however contain the correct category mapping list on the category tab.
2.) I need to be able to enter a markup value which will be applied to the "price" field in the "[url removed, login to view]" and generate the "Productprice" on the "[url removed, login to view]"
Looking to move this forward asap.