You will be prompted by Laura to enter items into Joann’s E-Quote system. The E-Quote system is only used for domestically shipped items. They have another portal for DI items.
The Equote template will provide a guide showing all the information required to complete the equote.
Request Netsuite Project ID from the respective Product Manager to obtain this necessary product information.
Once you have obtained all the product information, go to Joann’s vendor portal. https://vendorportal.joann.com/ and log in. You will find the username and password in Bitwarden.
Make sure you log into the correct Vendor accounts-
104566 for Tim Holtz and Sulyn
104645 for Wyla
Select eQuote, then eQuote Create
It will take you to a new screen to begin filling in info for the item
Season- Select from the drop down menu. The choices will change throughout the year. Send a screenshot of the choices to Sales to select the right one
Buyer- Select the buyer’s name from the drop down menu, Sales will provide
Vendor Style Number- Advantus item number
Product Description- Advantus product description. Do not include Tim Holtz’s name on his items, just the item description
UPC Number- 12 digit UPC-A number
Basic or Fashion- Basic product will be reordered throughout the year regardless of the season. Fashion product will be purchased for one season only
Country of Origin- COO in Netsuite
Domestic Delivery Point- USA. All items ship to US locations
Dropship to Stores or DSC- Usually DSC. Product that is delivered directly to a Jo-Ann’s store; select “Dropship to Stores”. Product that is delivered directly to a Jo-Ann’s Distribution Center; select “DSC”. Sales can confirm.
Can this product ship to Canada? Usually Yes, check with Product Manager if there is any compliance reason it cannot.
Country of Export- USA. All items set up in this portal will ship from one of our US warehouses.
Enter the info as shown above for Vendor Information
Hardline or Softline- Always Hardline. Softline is for fabrics only.
Category- 4 digit category number provided from Sales
Merchandise Category- 6 digit merch category, provided from Sales
Minimum Order Quantity- Use the Master Carton quantity
In Store FW- Sales will provide this information. Enter in YYYYWW format. Joann’s fiscal calendar operates a year ahead, so if you are in 2023 and Sales tell you week 35 the in-store FW would be 202435. You can see their fiscal calendar here and see the exact month and week that would fall on in 2024 based on their fiscal calendar.
Lead Time (Days)- Number of days required from time of confirmed Joann’s PO to the time the PO is delivered to the Joann’s store or DC. Standard is 150 days
Domestic HTSUS Number- Tariff Code from Netsuite
Is this a nested set? Select “Yes” if the product being quoted is contained within each other. For example, 3 baskets (small/medium/large). Otherwise, select no.
Leave Hardline Detail Information blank
Quote Validity Dates- auto-populate; leave as is
Product Cost- the cost Joann will pay for the item. Refer to the customer pricing database for a price structure, sales will usually provide as well. Always confirm the price with Sales.
Suggested Retail Price- List Price from Netsuite
Assortment Article- If the product quoted contains a variety (assortment) of individual products that will be ordered under one Jo-Ann’s Article Number, then the answer is “Yes”. If there is only one type of product for each individual Jo-Ann’s Article Number, then the answer is “No”.If “Yes”, a separate quote for each individual component piece of the assortment must be entered.
Pack- Inner pack quantity
Packs per Case- How many inner packs are in the master carton. This is not the Master Carton quantity.
***Pack multiplied by Packs Per Case=Master Carton Quantity. Example: An item has an inner pack of 2 eaches and a master carton quantity of 60; Pack= 2 and Packs per Case= 30***
Each Assembled Size- The out of package dimensions of an item, if applicable–example: carts. If this item does not require assembly use the sellable unit (UPC-A) dimensions.
Each Size- Sellable unit (UPC-A) dimensions
Pack Size- Inner Pack dimensions. If no inner pack, use Master Carton dimensions.
Case Size- Master Carton dimensions
When entering dimensions be sure to order them:
Length= longest dimension
Width= 2nd longest dimension
Height= shortest dimension
Material Component Breakdown- Listed in Netsuite
Leave this section blank
Item contains- Basically asking if Joann needs an SDS sheet for the item. Typically no, only yes for items made of chemicals–Read Right, wipes, etc.
Intended Age Grade- Sometimes listed in Netsuite, if unsure ask the Product Manager
Testing Required- Sometimes listed in Netsuite, if unsure ask the Product Manager
You only have to fill out this section if the intended age grade is all ages or ages 12 or below
Type of Packaging/Labeling- Refer to Packaging Types page. You can also look at like items to figure it out.
Quantity- Indicate the quantity offered for retail sale in each package. For example, if there is only one item per Article (with or without packaging) then the answer would be “1”. If the Article is a set, then indicate how many individual pieces are included in the set. For example, if the product is a set that includes a notebook with 4 markers, then the correct quantity is “5” since there are 5 pieces (notebook and 4 markers) included in the set.
Unit of Measure- UOM from Netsuite
Brand Name- TIMH=Tim Holtz, ADVA= non-branded, IMLX=IML boxes. Can be left blank
Preticketed with Retail Price- Yes if the list price is printed on the packaging, No if not. Usually no.
Upload the product image.
Select save to review your work. Add the eQuote ID to your spreadsheet.
After all items have been saved, go back to the home screen, select eQuote then eQuote Search.
Search using the Quote ID in the below.
Click the PDF button for the item and print the PDF for you to review
After you review and make corrections, email Tracey A. and cc Beth B. advise equotes complete and ask if they would like to review.
After all revisions have been done, save the final PDF here: SharePoint, Advantus Corp\Advantus Sales Operations – Documents\Customers\Joann’s\E-Quotes in the correct brand folder. Save by item number.
Then click back into the eQuote and submit.
Let Sales and Division know that Equotes have been submitted and request that they submit a pricing update task, so that you can enter pricing under 46JOA in Netsuite.