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
First, decide if you will work on your sheet in Google Docs or on your own PC using Excel.
2
* 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.
3
* If you decide to work in Excel (advanced), use "File / Download as", and then select Microsoft Excel. Then simply save it to a folder.
4
5
Second, how to work with the Items sheet:
6
* Some sample rows for reference, use sheet "Items" for your own inventory
7
DealerIDIDDescriptionQuantityPriceCostCategoryCategory2Supplier
8
JS1001Round Kitchen Table3$80.00$30.00FurnitureOak
9
JS1002Set of 4 Kitchen Chairs3$80.00$40.00FurnitureOak
10
JS1003Kitchen Chairs3$15.00$10.00FurnitureOak
11
JS1004Wedgwood Style Blue Vase2$25.00$15.00Home DecorPottery
12
JS1005
Canvas Print "Spring Song" (artist Simon Gl├╝cklich)
1$30.00$10.00Home DecorWall Art
13
* Leave the header row as row 1
14
* Rows 2 onward must be data only
15
* Do not leave any rows blank
16
* Do not change formats
17
* You MUST fill in DealerID, ItemID, Description, Quantity and Price
18
* Cost, the Category columns, and Supplier are optional, but might be needed if you are doing more classic retailing
19
20
Third, when done and ready to provide to the shop:
21
If working in Google Docs:
22
* 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).
23
* 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.
24
If working in Excel:
25
* You must email it to the shop
26
* Use your email program's "attach" feature. This is different for each email program so this is up to you.
27
28
This template is provided to you as a convenience, you will need to work with your shopkeeper, shop manager, or owner of shop to answer questions and import your inventory.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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...
Main menu