Step 1: Make a copy of the next tyre sheet. Click File -> Make a copy and save this sheet as your google sheet



Step 2: Fill up the 'Tyre' sheet as per the given template format. Read below guidelines before adding your data.

Do not change template headers.
Part name column is mandatory.



Avoid using Dash/Hyphen "-" symbol in the service name & Part number.

Do not add '%' symbol in the TAX Value column, keep only number. For Ex. 5

Only numeric value should be entered in Price, Tax. Decimal will be accepted



If Part have to be added in multiple languages, then enter the part name in both the languages separated by a "/" example MRF grip / قبضة MRF



Keep the number format as Automatic or plain text.



Remove all the extra columns other than the template. (If any)

Step 3: If you are adding any data in the CATEGORY column, ensure to first create these categories in GaragePlug.



Step 4: Download only service sheet in CSV (Comma Separated Values) format.



Step 5: Upload the CSV file into your GaragePlug account. Settings->Service & Part master->select part->upload CSV->choose file->select part type->UPLOAD



Notes : In case of dual language input, sometimes the language is not present in the excel we are using. So make sure to not create the CSV on your system, Just create and download from Google sheet in CSV format and upload.
Was this article helpful?
Cancel
Thank you!