Preparing Data For Importing

NOTE: Workshop Software recommends that you engage our services to carry out importing. While the import process may be something that you can do on your own, we often find that clients do not carry out the process correctly, or can sometimes end up investing more with us to fix the issues, and re-do the import. Workshop Software does not provide support around importing data, if you need our assistance, we are happy and willing to provide it, and may come at a cost. Please contact the support team if you require further details.

Customer Spreadsheet

Customers-Import-Template

Customer/Company Name

– Splitting up the First Name and Last Name –  https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

– Merge Company Names back together –  https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce

For the merging, you will need to sort by name on each column, starting at the last column, and moving back to the 3rd column. Once at the 2nd column, these are your first name and last name, and must remain split.  http://www.contextures.com/xlSort01.html

Customer Type.

Once you have the values in the first name, last name and Company Name columns, sort by company name  http://www.contextures.com/xlSort01.html

C = Company

I = Individual

Put a C in the first row with a company name in it. Drag this field until the last company name

Do the same for I where there are only first and last names

Spitting up the address

This is only required if the Suburb, State and Postcode are in the same column as the address

Split the address up –  https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

Merge the address back together without the suburb, state and postcode –  https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce

The columns left over, rename them to the respective names “suburb, state, and postcode. The merged field, name “Address”.

Phone Numbers

Phone numbers, and any number with a zero on the front, will remove the zero. Please follow this guide as the last stephttp://www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html

Vehicles Spreadsheet

Vehicles-Import-Template

Update the names of the Body types using this list: https://workshopsoftware.com/knowledge-base/technical-support/body-type-list If there is NO body type, or the body type isn’t on this list, use the word SEDAN

Update the Transmission Types using this list: https://workshopsoftware.com/knowledge-base/vehicles/transmission-category-list If there is NO transmission type, or the type isn’t on the list, use the word N/A.

Product Spreadsheet

Product-Import-Template

Product Types

Update the product types to have the below letters for the product type:

Stock           S
Labour (Labor)                                J
Sublet Repair A
Consumable W
Accessories X
Tyres T