完了済み

Google Spreadsheet Scripting

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.

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

------------------

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

スキル: Java, JavaScript

さらに表示: fill in a spreadsheet with data local companies search data entry spreadsheet: google craigslist yellow pages bluebook, manta, y, fill in a spreadsheet with data local companies search data entry spreadsheet google craigslist yellow pages bluebook manta yelp, script print spreadsheet google, javascript, display data google spreadsheet google sites, write spreadsheet google script, slider spreadsheet google, script email spreadsheet google, ebay spreadsheet google docs, spreadsheet google script sort, import large spreadsheet google docs, put excel spreadsheet google docs, link excel spreadsheet google maps, import spreadsheet google docs, sync google spreadsheet google calendar, google product search russia, using google product feed, google product list, convert spreadsheet google feed, arning fopen error google product sitemap generation failed

採用者について:
( 15件のレビュー ) Kreuzberg, Germany

プロジェクトID: #11528102

アワード:

Viqtor

Hi Zoe yes will write that code. What must be in column AQ or you use it just as a separator? Regards, Viktor

€35 EUR 1日以内
(19レビュー)
4.5

5人のフリーランサーが、このジョブに平均€38で入札しています

avinashjain09

Hello, I have done google sheet scripting work earlier, I am familiar with it. I can work today itself. I have read your requirements, please provide more details about the work. Can we have more discussion. I もっと

€50 EUR 2日以内
(31件のレビュー)
5.2
rvsofttechology

Hi, I have more than 5 years experience working on website and application development. I have been working on component and plugin development for Joomla and other CMS. I can work on this and can deliver it wit もっと

€24 EUR 10日以内
(0件のレビュー)
0.0
punig7

I am well-versed with Javascript and Google App Script and wont take more than a few hours, say 3-4 for me to finish it.

€24 EUR 1日以内
(0件のレビュー)
0.0
kpconsultancy

I have worked on algorithms (Perl, Java, PHP, JS) which processes CSV and other file formats, scrubs it, co-relate rows across CSV files and generate a new output file. One of my most credible project which heavily use もっと

€55 EUR 3日以内
(0件のレビュー)
0.0