Top,
Next
A.
Open the ‘Order Import Wizard’
I.
From Additional Functions #1 button.
II.
From the ‘Customer Orders’ 'Import' button.
B. Do
what the Import Wizard tells you
(3)
Enter / Re-Enter your company prefix
(4)
Click
to convert these
orders.
3.
What the Import Wizard tells you:
i)
Each object explains it purpose when you hold the mouse over it for a couple of
seconds.
B.
Questions answered by the Import Wizard:
i)
Have I downloaded from Yahoo yet?
ii)
Where do I save my Yahoo downloads?
iii)
How do I set up and save my Import Path?
iv)
What was the last order imported for this company?
v)
What Order Batches have I previously downloaded?
vi)
Have I missed importing any customer orders?
II.
Order validation before creating the Orders & Invoices:
ii)
Can I view / correct my new download? Yes.
iii)
Are there any bad ‘Freight Carrier services’?
iv)
Did the customer accidentally order the same thing twice on the same order?
v)
How many orders and order lines did I import?
vi)
What company will these orders be created in?
vii)
Have any of these orders been previously created?
i)
What ‘Preliminary Credit Card Authorization’ am I using?
ii)
Where will my download backups be stored?
iii)
Will my orders wait in ‘New Web Orders’ or be moved to ‘Open Orders’?
iv)
Will orders with stock available be invoices during conversion?
v)
Will invoiced orders be submitted for Credit Card funds capture?
vi)
Will invoiced orders be submitted to the Freight Carrier for tracking?
IV.
After converting Yahoo Download into Orders and Invoices:
i)
How do I back out an incorrectly done import?
4.
Yahoo export and download your customer orders.
A.
Log onto your Yahoo® store and select ![]()
B.
Export the desired orders (by clicking Export).
I.
Save your download to your standard directory
A.
Wizard realizes your files are ready:
II.
Check Display and click ‘Import’
III.
Your data is imported, examined and displayed for validation.
(1)
Double click to list all orders and invoices in YIC.
i)
Double click to define these Freight Carrier services.
I.
Credit Card Processing, Drop Ship, Invoice/Ship immediately?
A.
The
button is not available
until you verify the company prefix.
I.
You can change it to itself and tab out to activate the
BUTTON.
i)
This is to prevent accidentally importing into the wrong company.
i)
Customers (Bill To and Ship To) are automatically created during import.
ii)
Inventory items are validated / created during import.
iii)
Orders are created and inserted into the ‘New Web Order’ tab.
iv)
Freight, Tax, Special discounts are applied to the new order.
(1)
Freight is converted to a ‘Freight Each’ value for better ‘Back order’
handling’.
(2)
Tax for eligible states must be set up before use.
(3)
Special discounts must be set up before used.
C. Correct
problems as they occur.
I.
Invalid item codes from Yahoo
i)
The item ‘None’ is invalid.
ii)
Locate the correct item code by selecting it from the drop down.
(1)
Filtering by Supplier, Category or Sub-Category
v)
Pick a supplier and category
(1)
If this is truly a new item:
(2)
Your orders are displayed as they are imported
D.
When done processing, a recap of this batch is displayed.
I.
Clicking the
button provides the
following report:
E.
‘Ready to Invoice’ customer orders are displayed.
|
1) Yahoo Web Store Orders are exported, imported, analyzed, converted, and, if stock is available, shipped. 2) The ‘Order Import Wizard’ with only two clicks can prepare your orders for shipment 3) Orders, Invoices, Inventory items, Customers are all created on the fly. Step 3 |




(See ‘Yahoo export and download your customer orders.’ below)
![]() |
As soon as you’ve downloaded your data the Wizard
realizes there’s some work to do, makes the |

![]() |
Your batch of Yahoo orders are imported into temporary files, counted and can be displayed, modified, and corrected.
You MUST Enter /Re-Enter your |



OR 
![]()
![]()
![]()


![]()

![]()
![]()
![]()
![]()
![]()
![]()




![]()
![]() |
After importing the results are displayed. By examining the data you’ve downloaded, the Wizard already knows the starting / ending orders in the table, and therefore the range.
To avoid accidentally importing into the w
button becomes active.
|
Duplicate imports
are checked when you enter
your company prefix or click this option. This compares the newly imported, but
not yet processed orders against your existing orders, invoices and archived
invoices for that company and displays any duplicates.

This is NOT to prevent a double
import as duplicate order numbers are automatically blocked, but rather a
reminded to you about what orders will not be imported. There is a chance that
these are valid orders being imported into the w
To help troubleshoot anything found do the following:
You can use Find (Ctrl+F) to see
when these orders were previously imported and the status of their lines.

Bad freight carrier ‘Ship Via’
services
are check by clicking this
option. The number represents how many of these new orders have invalid freight
carrier services. There is a field in the Orders.csv from Yahoo called
‘Shipping’ which contains freight carrier services like ‘Ground’ or ‘2nd
Day Air’. These services must be matched to your approved Carrier / service
list. Any that are not will be displayed at this point.
Double click supplier to open the
Supplier form showing only freight carrier suppliers. Remove the filter to add
new suppliers and set their ‘Type of Vendor’ field to ‘Carrier’.


![]()

If you miss anything during your initial inspection of your imported orders the program will prompt your as it discovers problems.
You might encounter invalid ‘Ship
Via’, missing suppliers (without a supplier YIC can’t make

Normally the Yahoo ID
is visible in the data
presented in the ‘Order Item Description’ field
. If so, you can simply type that into the ‘Item Number’ drop down
box. If the item already exists with that code, it will be found in the drop
down, can be selected and you’re done.

New items shouldn’t actually use the ‘Yahoo ID’ so you may not find it.
If you know the supplier, category or sub-category you can filter the drop down list to show only those items.
For example by selecting the supplier from the
(after first setting it’s
status) you can ‘Filter’ the
‘Item Number’ contents thusly:
· Y (checked) = only show items belonging to this supplier.
· N (blank) = only show item that DON’T belong to this supplier.
· Grey = Disregard Supplier as a criteria.
So, if you know the category and supplier you could limit the drop down list to a particular supplier and category.
Adding sub-category filter:

If the ‘Item Number’ that is
missing from your inventory can’t be located by using this form you can add
this new item to your YIC Inventory as is or assign it a more appropriate ‘Item
Number’ by typing it into the ‘Item Number’ field and clicking
.


