Sedang Disiapkan

Product Data & Pricing

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.

Kemahiran: Excel, Visual Basic, Volusion

Lihat lebih lanjut: product data, pricing excel, data mapping, excel csv tab, amp visual basic, xls visual basic, move data excel, copy csv excel, collect product data, visual basic amp, copy product data, populate product, populate excel excel file, populate price excel, xls tab, tab data, product information excel, forward price excel, enter product, asap excel visual, excel product list, product cost, mapping field, price forward excel, field field mapping

Tentang Majikan:
( 5 ulasan ) St. Saviour, United Kingdom

ID Projek: #4055324