Skip to main content
All CollectionsGet Started with MydomaWelcome to Mydoma!
Best Practices for Studio Data Importers
Best Practices for Studio Data Importers
Dixie Willard avatar
Written by Dixie Willard
Updated over a week ago

If the thought of uploading each and every one of your many products, vendors, and clients into your new studio is overwhelming, don’t worry--we’ve got you covered with our studio data importers.

We want you to be as successful as possible so we’ve created this Best Practices Guide. Follow this guide and you’ll have your product, vendor, and client data set up in your studio in no time!

When ready download the spread sheet as a .csv file, you will email it to our team to upload for you!


Instructions to be able to edit templates:

Google Sheets

1. Click the button above to the spreadsheet template you would like.

2. Select to "Make a copy" this will create an editable copy of the spreadsheet for your own use.

3. Fill in the vendor, product, or client information as needed

***Do not add or change any headers.***

This is how we need this formatted to be able to upload your information

4. When ready download the spread sheet as a .csv file and email it to our team to upload for you!

* If you are unable to make a copy of the spreadsheet, it could be because you are not signed in on Google.


-or-

Excel/Numbers/Spreadsheet

1. Scroll down to the bottom of this article to select to download the excel file

2. Click on the file you'd like and open it in your preferred spreadsheet software

3. Fill in the vendor, product, or client information as needed

***Do not add or change any headers.***

This is how we need this formatted to be able to upload your information

4. When ready download the spread sheet as a .csv file and email it to our team to upload for you!


Overview

We’ll be using a CSV file to import your data. If you’re not familiar with CSV files, they’re essentially simple, plain text spreadsheets and can be easily created or edited in programs like Microsoft Excel and Google Sheets.

Before we get into the details, there are a few general rules to know:

  • When creating your CSV file, your column headings must be typed exactly as shown in the examples. Even a small variation can cause problems.

  • Check each column and row to make sure all the information is in the correct place.

  • Bold headings are required. (You don’t need to make them bold in the CSV file.) All other headings are optional.

  • If a heading has more than one option for the name, the options will be separated with a -or- . Choose only one of the options.

  • Any specific notes for a column’s requirements will be noted in brackets { }. These notes are for reference only and do not need to be included in your CSV file.

  • Once you have your information ready to go, make sure you have saved the file as a .csv before sending it to us.

Products

In order to import a product’s information, you must include a product code and a name for each entry.

Headings

Column

Header

Need To Know

A

product code

Required Field - No longer than 30 characters

B

name

Required Field - If you plan to use the QuickBooks integration: the product name needs to be less than 100 characters

C

tags

Separate each tag with a comma

D

manufacturer

---

E

price type

Choose either retail or trade. If any other value other than retail or trade is used, it defaults to retail.

F

price

---

G

description

---

H

product url

---

I

image

This must be a publicly accessible url to the image so that the importer can grab the image and then save it in our system.

Images in the spreadsheet will not be accepted and will not be imported. It has to be a url in order for us to be able to import it.

J

vendor

If a vendor profile doesn't already exist with this name, it will automatically create on in your vendor management list.

K

currency

This must be the three letter currency code or information in that cell will be dropped

Clients

In order to import your client information, you must include a first name and an email address for each entry. Clients will be imported as inactive.

Headings

Column

Header

Need To Know

A

first name

Required Field

B

last name

Required Field

C

email

Required Field - Must be a unique email that has not already been used in the studio

D

phone

---

E

street address

---

F

city

---

G

state -or- province

All states or provinces listed below this heading must be the two letter region code or the information in that cell will be dropped

H

postal -or- zip

---

I

country

All countries listed below this heading must be the two letter country code or the information in that cell will be dropped

Vendors

In order to import your vendor information, you must include a name for each entry.

Headings

Column

Header

Need To Know

A

name

Required Field

B

account number

---

C

notes

---

D

url

---

E

contact first name

This will be automatically listed as your primary contact when you send orders for a specific vendor.

F

contact last name

This will be automatically listed as your primary contact when you send orders for a specific vendor.

G

email

This will be automatically listed as your primary contact when you send orders for a specific vendor.

H

phone

---

I

street address

---

J

city

---

K

state -or- province

All states or provinces listed below this heading must be the two letter region code or the information in that cell will be dropped

L

postal -or- zip

---

M

country

All countries listed below this heading must be the two letter country code or the information in that cell will be dropped

When ready download the spread sheet as a .csv file, you will email it to our team to upload for you!

If you need any additional support, click the question mark in the upper right-hand corner to chat with a member of our team.

Happy designing!

Did this answer your question?