A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | DealerID | SKU | ID | Description | Quantity | Price | Cost | Category | Category2 | Supplier | ReorderQuantity | UseDiscountPct | DiscountPct | DiscountStartDate | DiscountEndDate | ImageFile1 | ImageFile2 | ImageFile3 | |||||||||
12 | JS1 | 001 | JS1/001 | Round Kitchen Table | 3 | $80.00 | $30.00 | Furniture | Oak | FALSE | C:\Images\JS1_001.jpg | C:\Images\JS1_001_sideview.jpg | C:\Images\JS1_001topview.jpg | ||||||||||||||
13 | JS1 | 002 | JS1/002 | Set of 4 Kitchen Chairs | 3 | $80.00 | $40.00 | Furniture | Oak | TRUE | 10 | 3/22/2019 | 3/24/2019 | https://website.com/images/JS1_002.jpg | |||||||||||||
14 | JS1 | 003 | JS1/003 | Kitchen Chairs | 3 | $15.00 | $10.00 | Furniture | Oak | FALSE | |||||||||||||||||
15 | JS1 | 004 | JS1/004 | Wedgwood Style Blue Vase | 2 | $25.00 | $15.00 | Home Decor | Pottery | FALSE | |||||||||||||||||
16 | JS1 | 005 | JS1/005 | Canvas Print "Spring Song" (artist Simon Glücklich) | 1 | $30.00 | $10.00 | Home Decor | Wall Art | FALSE | |||||||||||||||||
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 | * Up to 3 images can be associated to an item for record keeping, in the software only the first one is shown (preview when entering item into Cash Register) | ||||||||||||||||||||||||||
30 | - Images should be JPG with compression for space saving | ||||||||||||||||||||||||||
31 | - Images can be supplied to the shop | ||||||||||||||||||||||||||
32 | - Please reduce size of image to no more larger than 1024x768 to avoid slow operations | ||||||||||||||||||||||||||
33 | - Images can be located on a public URL, meaning a website that does not require login to see content. Example URL: https://www.mywebsite.com/images/JS_001.jpg | ||||||||||||||||||||||||||
34 | |||||||||||||||||||||||||||
35 | So you say you as a Dealer want to create your own barcode labels? | ||||||||||||||||||||||||||
36 | You can do this, but you need to do this in a coordinated way with the shop: | ||||||||||||||||||||||||||
37 | * Discuss with the shop manager your needs. | ||||||||||||||||||||||||||
38 | * 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. | ||||||||||||||||||||||||||
39 | * You would certainly need to acquire a way to print your own barcodes, there are many such solutions. | ||||||||||||||||||||||||||
40 | * 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. | ||||||||||||||||||||||||||
41 | |||||||||||||||||||||||||||
42 | Third, when done and ready to provide to the shop: | ||||||||||||||||||||||||||
43 | If working in Google Docs: | ||||||||||||||||||||||||||
44 | * 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). | ||||||||||||||||||||||||||
45 | * 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. | ||||||||||||||||||||||||||
46 | If working in Excel: | ||||||||||||||||||||||||||
47 | * You must email it to the shop. | ||||||||||||||||||||||||||
48 | * Use your email program's "attach" feature. This is different for each email program so this is up to you. | ||||||||||||||||||||||||||
49 | |||||||||||||||||||||||||||
50 | Fourth, how the shop will import the Items into the Item Master. Remember this section is for the shop, not for the Dealer! | ||||||||||||||||||||||||||
51 | Method 1 - Using an Excel File saved from a shared Google sheet | ||||||||||||||||||||||||||
52 | In your Email program | ||||||||||||||||||||||||||
53 | * Assuming Gmail since this is a Google sheet. | ||||||||||||||||||||||||||
54 | * Find the email that your Dealer "shared" with you | ||||||||||||||||||||||||||
55 | * Click the link to "Open in Sheets". | ||||||||||||||||||||||||||
56 | * 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. | ||||||||||||||||||||||||||
57 | * 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. | ||||||||||||||||||||||||||
58 | In GoAntiquing | ||||||||||||||||||||||||||
59 | * Go to Tasks / Item Master | ||||||||||||||||||||||||||
60 | * From main menu select “Tools / Import Item Info” | ||||||||||||||||||||||||||
61 | * Page 1: Pick file type as Excel, pick the filename, pick the sheet name, and select that sheet does have column headers. Click Next. | ||||||||||||||||||||||||||
62 | * 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. | ||||||||||||||||||||||||||
63 | * 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. | ||||||||||||||||||||||||||
64 | * 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! | ||||||||||||||||||||||||||
65 | Method 2 - Using Copy/Paste | ||||||||||||||||||||||||||
66 | In your Email program | ||||||||||||||||||||||||||
67 | * Assuming Gmail since this is a Google sheet. | ||||||||||||||||||||||||||
68 | * Find the email that your Dealer "shared" with you | ||||||||||||||||||||||||||
69 | * Click the link to "Open in Sheets". | ||||||||||||||||||||||||||
70 | * Then select the sheet that was usd by Dealer, usually "Items". | ||||||||||||||||||||||||||
71 | * Next, press Ctrl-a to "select all" | ||||||||||||||||||||||||||
72 | * Then press Ctrl-c to copy all that is selected to the "clipboard" | ||||||||||||||||||||||||||
73 | In GoAntiquing | ||||||||||||||||||||||||||
74 | * Go to Tasks / Item Master | ||||||||||||||||||||||||||
75 | * From main menu select “Tools / Import Item Info” | ||||||||||||||||||||||||||
76 | * Page 1: The screen will detect that you have properly formatted data in the clipboard and pre-select type "Clipboard / Tab Delimited" | ||||||||||||||||||||||||||
77 | * 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. | ||||||||||||||||||||||||||
78 | * 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. | ||||||||||||||||||||||||||
79 | * 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! | ||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||
100 |