Template - Dealer Item Inventory Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
DealerIDIDDescription
Quantity
PriceCostCategory
Category2
Supplier
ReorderQuantity
UseDiscountPct
DiscountPct
DiscountStartDate
DiscountEndDate
11
JS1001Round Kitchen Table3$80.00$30.00FurnitureOakFALSE
12
JS1002Set of 4 Kitchen Chairs3$80.00$40.00FurnitureOakTRUE103/22/20193/24/2019
13
JS1003Kitchen Chairs3$15.00$10.00FurnitureOakFALSE
14
JS1004Wedgwood Style Blue Vase2$25.00$15.00
Home Decor
PotteryFALSE
15
JS1005
Canvas Print "Spring Song" (artist Simon Glücklich)
1$30.00$10.00
Home Decor
Wall ArtFALSE
16
* Leave the header row as row 1
17
* Rows 2 onward must be data only
18
* Do not leave any rows blank
19
* Do not change formats
20
* You MUST fill in DealerID, ItemID, Description, Quantity and Price
21
* Optional column are shown in light yellow in examples, described below.
22
* 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)
23
* To specify optional Discounting, fill in the 4 columns at end, UseDiscountPct must be set to TRUE
24
- UseDiscountPct must be set to either TRUE or FALSE
25
- DiscountPct is entered as a regular number, e.g. 10% discount is to entered as 10, not 10%, and not .10
26
- DiscountStartDate is the date the discount begins
27
- DiscountEndDate is the date the discount ends, use 12/31/9999 for neverending discount
28
29
So you say you as a Dealer want to create your own barcode labels?
30
You can do this, but you need to do this in a coordinated way with the shop:
31
* Discuss with the shop manager your needs.
32
* Agree on a "prefix" for all the values in your Item ID column, for example JS. Then items would JS001, JS002, and so on.
33
* You would certainly need to acquire a way to print your own barcodes, there are many such solutions.
34
* 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.
35
36
Third, when done and ready to provide to the shop:
37
If working in Google Docs:
38
* 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).
39
* 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.
40
If working in Excel:
41
* You must email it to the shop.
42
* Use your email program's "attach" feature. This is different for each email program so this is up to you.
43
44
Fourth, how the shop will import the Items into the Item Master. Remember this section is for the shop, not for the Dealer!
45
In your Email program
46
* Assuming Gmail since this is a Google sheet.
47
* Find the email that your Dealer "shared" with you
48
* Click the link to "Open in Sheets".
49
* 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.
50
* 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.
51
In GoAntiquing
52
* Go to Tasks / Item Master
53
* From main menu select “Tools / Import Item Info”
54
* Page 1: Pick file type as Excel, pick the filename, pick the sheet name, and select that sheet does have column headers. Click Next.
55
* 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.
56
* 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.
57
* 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!
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
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
Loading...