ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Important: To use this sheet use "File / Make a Copy" - please do not request access to edit it.
3
4
First, decide if you will work on your sheet in Google Docs or on your own PC using Excel.
5
* If you decide to work with it in Google Docs (recommended), you will need to Save this template to your own Google account by using "File / Make a copy" from the menu.
6
* If you decide to work in Excel (advanced), use "File / Download as", and then select Microsoft Excel. Then simply save it to a folder.
7
8
Second, how to work with the Items sheet:
9
* Some sample rows for reference, use sheet "Items" for your own inventory
10
* NOTE: the columns SKU and ID are intended as SKU for the Dealer's item ID#, and ID is generated by the spreadsheet as DealerID+SKU. This is a *new* approach, and anyone who prefers the old wy of just using ID themselves are welcome to use the old way.
11
DealerIDSKUIDDescription
Quantity
PriceCostCategory
Category2
Supplier
ReorderQuantity
UseDiscountPct
DiscountPct
DiscountStartDate
DiscountEndDate
12
JS1001JS1/001Round Kitchen Table3$80.00$30.00FurnitureOakFALSE
13
JS1002JS1/002Set of 4 Kitchen Chairs3$80.00$40.00FurnitureOakTRUE103/22/20193/24/2019
14
JS1003JS1/003Kitchen Chairs3$15.00$10.00FurnitureOakFALSE
15
JS1004JS1/004Wedgwood Style Blue Vase2$25.00$15.00
Home Decor
PotteryFALSE
16
JS1005JS1/005
Canvas Print "Spring Song" (artist Simon Glücklich)
1$30.00$10.00
Home Decor
Wall ArtFALSE
17
* Leave the header row as row 1
18
* Rows 2 onward must be data only
19
* Do not leave any rows blank
20
* Do not change formats
21
* You MUST fill in DealerID, SKU, Description, Quantity and Price. Do NOT fill in ID, this is automatically populated. Important - the combination of DealerID, a slash, and SKU cannot exceed 16 characters.
22
* Optional column are shown in light yellow in examples, described below.
23
* Cost, the Category columns, Supplier and ReorderQuantity are optional, but might be needed if you are doing more classic retailing (column header color light yellow)
24
* To specify optional Discounting, fill in the 4 columns at end, UseDiscountPct must be set to TRUE
25
- UseDiscountPct must be set to either TRUE or FALSE
26
- DiscountPct is entered as a regular number, e.g. 10% discount is to entered as 10, not 10%, and not .10
27
- DiscountStartDate is the date the discount begins
28
- DiscountEndDate is the date the discount ends, use 12/31/9999 for neverending discount
29
30
So you say you as a Dealer want to create your own barcode labels?
31
You can do this, but you need to do this in a coordinated way with the shop:
32
* Discuss with the shop manager your needs.
33
* In this sheet the SKU column is the Dealer's ItemID#. The column ID is a combination of DealerID and SKU and is not to be edited so is in red.
34
* You would certainly need to acquire a way to print your own barcodes, there are many such solutions.
35
* When your inventory is imported via this sheet or Excel, assuming unique Item ID, the person operating the barcode scanner will simply scan your tag and it will find the item.
36
37
Third, when done and ready to provide to the shop:
38
If working in Google Docs:
39
* To send this sheet from Google Docs directly to the shop via email, use "File / Email as attachment" from the menu, then on the popup select "Microsoft Excel" from the dropdown choice (which defaults to PDF).
40
* To SHARE this sheet with the shop, use "File / Share" from the menu, and then on popup enter the email address of the shop. Follow through any extra steps to send.
41
If working in Excel:
42
* You must email it to the shop.
43
* Use your email program's "attach" feature. This is different for each email program so this is up to you.
44
45
Fourth, how the shop will import the Items into the Item Master. Remember this section is for the shop, not for the Dealer!
46
Method 1 - Using an Excel File saved from a shared Google sheet
47
In your Email program
48
* Assuming Gmail since this is a Google sheet.
49
* Find the email that your Dealer "shared" with you
50
* Click the link to "Open in Sheets".
51
* Then use "File/Download", and choose to download as Excel, save to Documents and give the new Excel file a name you can associate to this Dealer and this time frame.
52
* Instead of sharing the Dealer may have used the option to "Email as attachment", if they did save the file to Documents with a good name.
53
In GoAntiquing
54
* Go to Tasks / Item Master
55
* From main menu select “Tools / Import Item Info”
56
* Page 1: Pick file type as Excel, pick the filename, pick the sheet name, and select that sheet does have column headers. Click Next.
57
* Page 2: Click the “Auto” button to automatically map columns from sheet to the Item Master. All columns should map automatically to correct fields within GoAntiquing!. Click Next.
58
* Page 3: This previews the data. If you get an error click Back, then Next again. If an error persists, the sheet might have some inconsistent data, such as non-numeric in a number only column, or missing data, etc. Click Next.
59
* Page 4: Click Import Now. All settings should be good as is, more advanced options for how to import or update should be self-explanatory. Do notice that you have options on how to address Quantity when importing, by default it will set the quantity for NEW items and ADD Quantity for existing items!
60
Method 2 - Using Copy/Paste
61
In your Email program
62
* Assuming Gmail since this is a Google sheet.
63
* Find the email that your Dealer "shared" with you
64
* Click the link to "Open in Sheets".
65
* Then select the sheet that was usd by Dealer, usually "Items".
66
* Next, press Ctrl-a to "select all"
67
* Then press Ctrl-c to copy all that is selected to the "clipboard"
68
In GoAntiquing
69
* Go to Tasks / Item Master
70
* From main menu select “Tools / Import Item Info”
71
* Page 1: The screen will detect that you have properly formatted data in the clipboard and pre-select type "Clipboard / Tab Delimited"
72
* Page 2: Click the “Auto” button to automatically map columns from sheet to the Item Master. All columns should map automatically to correct fields within GoAntiquing!. Click Next.
73
* Page 3: This previews the data. If you get an error click Back, then Next again. If an error persists, the sheet might have some inconsistent data, such as non-numeric in a number only column, or missing data, etc. Click Next.
74
* Page 4: Click Import Now. All settings should be good as is, more advanced options for how to import or update should be self-explanatory. Do notice that you have options on how to address Quantity when importing, by default it will set the quantity for NEW items and ADD Quantity for existing items!
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100