Google Spreadsheet Programming
€8-30 EUR
Thanh toán khi bàn giao
I have a 3 sheets google Spreadsheet and a script programming.
1. Sheet3 (this sheet is updated daily by me)
you see in collumn A the Name of the product OR the Sizes we have for the Product.
you see in collumn B the SKU for the product which is very important
you see in collumn D the number of products we have for the size in Collumn A
this sheet is updated daily, so tomorrow, there might be more products or less and the same product might be in another row
2. Sheet 2
you see in A:B 1:10 size mapping
001_32 / 2XS in Sheet3 is 2XS in Sheet1
3. Sheet 1
This is the important sheet i would like to have updated automaticly if i Update Sheet3
I include SKUs in Collumn A
and i need updated automaticly for my given SKUs
in B: The name of the SKU from Sheet3 Collumn A
in C: The number for Size XS for the SKU from Sheet3 Collumn D
in D: The number for Size S for the SKU from Sheet3 Collumn D
.....
Often, SKUs don't have all Sizes, then please type in the Sizes in Sheet1 "no"
Often, SKUs don't have any Sizes, then please type in the sizes in Sheet 1 "no"
For me, only the SKUs are interesting, which have the numbers, i asked for.
----------------
Important:
i include the SKUs in Sheet1 Collumn A and i'll include more of these SKU and maybe delete some of them, so i need to have the chance of Sheet1 Collumn A
------------------
please try only if you know how to do scripts in google spreadsheets
[url removed, login to view]
ID dự án: #10654806
Về dự án
3 freelancer chào giá trung bình€27 cho công việc này
Hello Sir, Your project interests me. I will be available to participate in its realization. for more information contact me zakariaa benslimane
Hi! My name is Felipe and I'm a Google Apps Script developer from Brazil, how are you? So, I've checked your spreadsheet and I am sure that I can work with you on this project, so, if you are interested, just send me a Thêm