Link image names to rows by sku and add additonal columns to data
$30-250 USD
Paid on delivery
We need image names to be linked to data by sku in multiple excel tables.
Each table will also need data columns added. We have an example table with the data displayed as it should be. This can be used as a basis to add the necessary additional columns and make the necessary changes.
Column heading 'Item', renamed 'sku'.
Column heading 'Description' retained but duplicated and this new column headed 'name'
Column heading 'stock' renamed 'gzm_stock' - find replace 'si' with 'yes'
Column heading 'price' renamed 'cost' - needs to display as number with 2 decimals,
New column heading 'price' - multiply cost column by 1.45
Column heading 'discount' renamed 'gzm_discount' - data displyed as number %
New columns - store,type,websites,status,tax_class_id,visibility,is_in_stock,qty,attribute_set,weight
(all with exact same data for every row) i.e. 'store' value for every row would be 'admin'
New columns -
image,small_image,thumbnail
(all with image title link up according to sku)
New column -
category_ids (all values filled with title of table)
Tables can be merged into one and need to be provided as csv
Project ID: #9980692
About the project
Awarded to:
Hello I can get you these tasks performed using a simple VBA Macro. Can you please share me a sample file if you are interested. Thanks
22 freelancers are bidding on average $88 for this job
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu More
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have More
Sir, Greetings! I am ready to start immediately. Please give me the chance, I will give my best efforts. Thank you so much! Regards Adnan
Hi there! My name is Johana Bracho. I am 29 years old. Spanish is my native language. I graduated in Science, Biology, in the University of Los Andes (ULA), Mérida-Venezuela. I am pursuing my PhD in Tropical Ecology at More
Hello, I understand you need some changes made to a spreadsheet. This seems fairly basic for me to do so I should deliver really quick. Just let me know how I can do this for you.
I understood all the instruction and still required some guidance on it and i can complete this work in 2 days. Thankyou