Important: To use this sheet use "File / Make a Copy" - please do not request access to edit it.
First, decide if you will work on your sheet in Google Docs or on your own PC using Excel.
* 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.
* If you decide to work in Excel (advanced), use "File / Download as", and then select Microsoft Excel. Then simply save it to a folder.
Second, how to work with the Items sheet:
* Some sample rows for reference, use sheet "Items" for your own inventory
|JS1||001||Round Kitchen Table||3||$80.00||$30.00||Furniture||Oak||FALSE|
|JS1||002||Set of 4 Kitchen Chairs||3||$80.00||$40.00||Furniture||Oak||TRUE||10||3/22/2019||3/24/2019|
|JS1||004||Wedgwood Style Blue Vase||2||$25.00||$15.00|
Canvas Print "Spring Song" (artist Simon Glücklich)
* Leave the header row as row 1
* Rows 2 onward must be data only
* Do not leave any rows blank
* Do not change formats
* You MUST fill in DealerID, ItemID, Description, Quantity and Price
* Optional column are shown in light yellow in examples, described below.
* 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)
* To specify optional Discounting, fill in the 4 columns at end, UseDiscountPct must be set to TRUE
- UseDiscountPct must be set to either TRUE or FALSE
- DiscountPct is entered as a regular number, e.g. 10% discount is to entered as 10, not 10%, and not .10
- DiscountStartDate is the date the discount begins
- DiscountEndDate is the date the discount ends, use 12/31/9999 for neverending discount
So you say you as a Dealer want to create your own barcode labels?
You can do this, but you need to do this in a coordinated way with the shop:
* Discuss with the shop manager your needs.
* Agree on a "prefix" for all the values in your Item ID column, for example JS. Then items would JS001, JS002, and so on.
* You would certainly need to acquire a way to print your own barcodes, there are many such solutions.
* 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.
Third, when done and ready to provide to the shop:
If working in Google Docs:
* 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).
* 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.
If working in Excel:
* You must email it to the shop.
* Use your email program's "attach" feature. This is different for each email program so this is up to you.
Fourth, how the shop will import the Items into the Item Master. Remember this section is for the shop, not for the Dealer!
In your Email program
* Assuming Gmail since this is a Google sheet.
* Find the email that your Dealer "shared" with you
* Click the link to "Open in Sheets".
* 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.
* 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.
* Go to Tasks / Item Master
* From main menu select “Tools / Import Item Info”
* Page 1: Pick file type as Excel, pick the filename, pick the sheet name, and select that sheet does have column headers. Click Next.
* 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.
* 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.
* 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!