please try only if you know how to do scripts in google spreadsheets. Excel is not possible
Have a look here:
[url removed, login to view]
I need an improvement of my Google spreadsheet which automaticly updates my datas by click
what does my Script is doing now??
It changes Sheet 1 collumn B-M from Sheet 3 (CSV-Daten) by clicking "SKU" in the navigation which starts a Javasctipt in Google Spreadsheets
1. Sheet 3 (CSD-Daten)
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 that is updated automaticly if i Update Sheet3 and click "SKU" in the navigation
I include SKUs in Collumn A
The Sheet is now uptading automaticly for my given SKUs the next collumms
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
and so on
it changes, too the colors (0 = red, >1 green)
Often, SKUs don't have all Sizes, then it types in the Sizes in Sheet1 "no" and changes color to yellow
Often, SKUs don't have any Sizes, then it types in the sizes in Sheet 1 "no" and changes color to yellow
For me, only the SKUs are interesting, which have the numbers, i asked for.
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
What do i need.
1. exact the same for collumn "N" - which icludes the new Size "one size"
2. exact the same for collumns "AC" - "BO" which includes new sizes
here you can use the same code for the new sizes
3. Collumn "O": Here i need a sum of all products in Stock for these SKU
Please use the same colors (no = yellow, 0 = red, >1 = green