Google Apps Script Debugging Required
Budget: $1,500 – $3,000 USD
The google apps script on the sheets file here:
https://docs.google.com/spreadsheets/d/1ph19uCOLHnqqF47AWgmxAoGlIoL5mw_Q2q2cvulI_LA/edit?usp=drive_link
Does the following:
we export 2 csv files daily from different order platforms
script makes a picker to select the csv files from google drive
unit numbers are populated on to two tabs in the google sheet depending on the platform the csv was downloaded from, data is entered into cells using the date and SKU code as coordinates.
Until now our Shopify csv files only included data for 5 days, I have increased this to 7 days, but am receiving the following error when I run the script:
"Exception: The number of columns in the data does not match the number of columns in the range. The data has 5 but the range has 7."
I have changed:
var dates = shSHOPIFY.getRange("C2:G2").getDisplayValues()
to
var dates = shSHOPIFY.getRange("C2:I2").getDisplayValues()
and have changed:
shSHOPIFY.getRange(4, 4, values.length, 5).setValues(values)
to
shSHOPIFY.getRange(4, 4, values.length, 7).setValues(values)
but there's obviously something I'm still missing. I need this fixed within 4 hours, please let me know if you can help.
sample csv file attached.
Thank you
https://docs.google.com/spreadsheets/d/1ph19uCOLHnqqF47AWgmxAoGlIoL5mw_Q2q2cvulI_LA/edit?usp=drive_link
Does the following:
we export 2 csv files daily from different order platforms
script makes a picker to select the csv files from google drive
unit numbers are populated on to two tabs in the google sheet depending on the platform the csv was downloaded from, data is entered into cells using the date and SKU code as coordinates.
Until now our Shopify csv files only included data for 5 days, I have increased this to 7 days, but am receiving the following error when I run the script:
"Exception: The number of columns in the data does not match the number of columns in the range. The data has 5 but the range has 7."
I have changed:
var dates = shSHOPIFY.getRange("C2:G2").getDisplayValues()
to
var dates = shSHOPIFY.getRange("C2:I2").getDisplayValues()
and have changed:
shSHOPIFY.getRange(4, 4, values.length, 5).setValues(values)
to
shSHOPIFY.getRange(4, 4, values.length, 7).setValues(values)
but there's obviously something I'm still missing. I need this fixed within 4 hours, please let me know if you can help.
sample csv file attached.
Thank you