Submitting a JO-ANN E-Quotes
You will be prompted by PD to enter items into Joannâs E-Quote system. The E-Quote system is only used for items that ship domestically. They have another portal for DI items (GroveSite).
Use the template found here to gather all of your information:
There is a Netsuite report that will generate all the info needed. Type Project number in the Global Search Field.
Use the Vendor Portal Database to log in.
Username: VEN_NIBANEZ
PW: Ask PD
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
Department Number â This is the unique department number associated with the product that is being quoted. Leave this blank.
Product Description- Advantus product 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- Most products are Hardline. Softline is for fabrics only. If it is a Softline fabric item complete the below.
Reference Article Number â Article used for forecast consumption on new basic articles.
Category- 4 digit category number provided from Sales.
Merchandise Category- 6 digit merch category, provided from Sales.
Layout Module Family â The Layout Module Family names have been pre-defined and should be provided by the Jo-Ann buyer. You can get this information 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 Sales tell you week 35 of 2022. The in-store FW is 202335.
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. For Wyla.
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.
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
Material Component Breakdown- Listed in Netsuite; if unsure check with Product Manager
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- Listed in Netsuite.
Testing Required- Yes.
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- WYLA or Can be left blank.
Preticketed with Retail Price- Yes if the list price is printed on the packaging, No if not.
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, let Sales know and ask if they would like to review.
After all revisions have been done, save the final PDF here: S:\Sales & Marketing\Customers\Joannâs\E-Quotes\ in the correct brand folder. Save by item number.
Then click back into the eQuote and submit.
After they have been submitted, send Joannâs price to Sales under customer number 46JOAW and 46JOAWD.