Google Spreadsheet Programming

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]

JavaScript

ID projekta: #10654806

Več o projektu