Skip to main content

Import QuickBooks Products into EmbTrak

·         From the EmbTrak Home Screen,  go to System à Import à QuickBooks à QuickBooks 2006 – 2014 Product Import

                   IQP1

  • As the Import program runs, a pop-up list displays the items that are being imported.  Inactive items are not eligible to be imported into EmbTrak.
    • Set Product Type and Size Type for items that have not been previously imported by clicking on the down arrow and picking the appropriate option.
    • If the Product Type is blank when the import program runs, an eror message will display that an item is missing a Product Type, giving recommendation to fill in the missing information and retry the Import.
      • Click OK to continue.
      • The program will finish and not import the problem items.
      • To import the items, rerun the import program and complete the Product Type field
    • If the Size Type is blank when the import program runs, the item will import into EmbTrak with a blank for SizeType

                                IQP2 

  • Once all items have a Product Type and Size Type, Click Continue.
  • After the Import program completes, a dialog box displays, noting the total number of Products that were imported.  
                      IQP3

 

When the Product exists in QuickBooks, but not in EmbTrak

  • The Import program will set the EmbTrak fields as follows: 
 
Product Number = Quickbooks Item Name/Number
Description = QuickBooks Description on Sales Transaction
Product Type = Product Type set during Import program
Size Type = Size Type set during Import program

 

IQP4A  IQP5A

  • Notes: 
    • If the Description on Sales Transaction is blank in QuickBooks, the Description in EmbTrak will remain blank.  
    • Product Syles and Product Pricing will not not be set up with the Import program.


When the Product exists in both QuickBooks and EmbTrak prior to Import

  • Updates will occur when a product has a different QuickBooks Description.  The new description will carry over to EmbTrak.  
    • If this item exists on a Quote or Sales Order, the line item description will also be updated.

 

Join our EmbTrak newsletter today for free.

The more I work with EmbTrak, the more I have come to appreciate its capabilities and efficiency as a workflow processing system. The ease of interface and simplicity of data mining/retrieval make... Read More

Eric Hann
Bermuda Sands Apparel of Embroidery Operations Manager

The proofing feature in EmbTrak has dramatically improved efficiency and accuracy in communicating the many details of orders with customers. Our customers, sales reps, and production team have a... Read More

James Hedges
Simms Fishing of Customer Service Rep

The proofing feature in EmbTrak has dramatically improved efficiency and accuracy in communicating the many details of orders with customers. Our customers, sales reps, and production team have a... Read More

James Hedges
Simms Fishing of Customer Service

"After adding EmbTrak, our color coordination staff was able to handle a 48% sales increase in March over the previous year's level with less overtime and no increase in headcount. EmbTrak has been... Read More

James Howarth
TaylorMade-Adidas Golf of National Services Manager

“EmbTrak makes training new production operators much easier by providing detailed thread-up instructions, a list of required cones, a production dispatch list and a printed Work Order with a color... Read More

Lori Young
Dunlop Sports Group of Production Supervisor

"It's a beautiful thing--you select a Work Order, you select a design from the customer's dropdown list, you click ‘Match’ and all the thread colors come in, and you're done!"

Kim Washburn
Dunlop Sports Group of Color Coordinator

“I love EmbTrak. I can do the color coordination on an order in about half the time it took without EmbTrak.”

Tara Cutts
Fairway & Greene of Color Coordinator

“EmbTrak is the best thing you’ve ever done for our business."

Sales Rep
Antigua Group of IT Department

"October was the highest sales month in the history of Antigua. It was so busy that even the VP of Operations was in the warehouse picking product for orders. However, the Order Coordination area,... Read More

Chris Devous
Antigua Group of Director of Development