Order Import Wizard

Top, Next

Table of contents:

                                                               

Table of contents. 2

1. Summary: 4

2. How to import 4

A. Open the ‘Order Import Wizard’ 4

I. From Additional Functions #1 button. 4

II. From the ‘Customer Orders’ 'Import' button. 4

B. Do what the Import Wizard tells you. 5

I. 5 Easy steps: 5

(1) Download your data. 5

(2) Click ‘Import’ 5

(3) Enter / Re-Enter your company prefix. 6

(4) Click  to convert these orders. 6

(5) The new batch of Yahoo Orders will be converted into Orders and Invoices depending on the preference defaults displayed in. 7

3. What the Import Wizard tells you: 7

i) Each object explains it purpose when you hold the mouse over it for a couple of seconds. 7

B. Questions answered by the Import Wizard: 8

I. Pre-Import questions: 8

i) Have I downloaded from Yahoo yet?. 8

ii) Where do I save my Yahoo downloads?. 9

iii) How do I set up and save my Import Path?. 9

iv) What was the last order imported for this company?. 9

v) What Order Batches have I previously downloaded?. 9

vi) Have I missed importing any customer orders?. 9

vii) What do I do next?. 9

II. Order validation before creating the Orders & Invoices: 9

i) What have I just imported?. 9

ii) Can I view / correct my new download? Yes. 9

iii) Are there any bad ‘Freight Carrier services’?. 9

iv) Did the customer accidentally order the same thing twice on the same order?. 10

v) How many orders and order lines did I import?. 10

vi) What company will these orders be created in?. 10

vii) Have any of these orders been previously created?. 10

III. Conversion Preferences. 10

i) What ‘Preliminary Credit Card Authorization’ am I using?. 10

ii) Where will my download backups be stored?. 10

iii) Will my orders wait in ‘New Web Orders’ or be moved to ‘Open Orders’?. 10

iv) Will orders with stock available be invoices during conversion?. 10

v) Will invoiced orders be submitted for Credit Card funds capture?. 10

vi) Will invoiced orders be submitted to the Freight Carrier for tracking?. 10

IV. After converting Yahoo Download into Orders and Invoices: 10

i) How do I back out an incorrectly done import?. 10

4. Yahoo export and download your customer orders. 11

A. Log onto your Yahoo® store and select .................. 11

B. Export the desired orders (by clicking Export). 12

I. Save your download to your standard directory. 12

5. Import details. 12

A. Wizard realizes your files are ready: 12

I. As soon as you’ve down loaded ‘Orders/ Items/ Options’ from Yahoo, the text changes to the following: 12

II. Check Display and click ‘Import’ 13

III. Your data is imported, examined and displayed for validation. 13

IV. Duplicate Import .................................. 13

(1) Double click to list all orders and invoices in YIC. 13

V. Bad freight / ‘Ship Via’ ........................... 14

i) Double click to define these Freight Carrier services. 14

B. Set your preferences. 14

I. Credit Card Processing, Drop Ship, Invoice/Ship immediately?. 14

6. Processing details: 15

A. The  button is not available until you verify the company prefix. 15

I. You can change it to itself and tab out to activate the  BUTTON. 15

i) This is to prevent accidentally importing into the wrong company. 15

B. Click  when available. 15

i) Customers (Bill To and Ship To) are automatically created during import. 15

ii) Inventory items are validated / created during import. 15

iii) Orders are created and inserted into the ‘New Web Order’ tab. 15

iv) Freight, Tax, Special discounts are applied to the new order. 15

(1) Freight is converted to a ‘Freight Each’ value for better ‘Back order’ handling’. 15

(2) Tax for eligible states must be set up before use. 15

(3) Special discounts must be set up before used. 15

C. Correct problems as they occur. 15

I. Invalid item codes from Yahoo. 16

i) The item ‘None’ is invalid. 16

ii) Locate the correct item code by selecting it from the drop down. 17

iii) Then click DONE. 17

iv) Finding an item: 17

(1) Filtering by Supplier, Category or Sub-Category. 17

v) Pick a supplier and category. 18

(1) If this is truly a new item: 18

(2) Your orders are displayed as they are imported. 18

D. When done processing, a recap of this batch is displayed. 19

I. Clicking the  button provides the following report: 19

E. ‘Ready to Invoice’ customer orders are displayed. 20

 

 Top, Next

 

1. Summary:

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

 

2. How to import

A. Open the ‘Order Import Wizard’

I. From Additional Functions #1 button.

II. From the ‘Customer Orders’ 'Import' button.

  Top, Next

B. Do what the Import Wizard tells you

I. 5 Easy steps:

Text Box: The Wizard:
1.      looks in your import directory, 
2.      Determines that you haven’t downloaded the new batch of orders from Yahoo
3.      Tells you to download
 
Top right screen:
You can see that last order import for each company by entering the company prefix.
 
See Batches:
You can display the batch from which the last orders were import by locating it in the ‘See Batches’ drop down.
 
YOU MUST GO DOWNLOAD FROM YAHOO. 
(See ‘Download and import your customer orders’ below.
 

  Top, Next

(1) Download your data

(See ‘Yahoo export and download your customer orders.’ below)

(2) Click ‘Import’

As soon as you’ve downloaded your data the Wizard realizes there’s some work to do,

makes the  button available and tells you to .

 

 

Top, Next

(3) Enter / Re-Enter your company prefix

 

 

Top, Next

(4) Click  to convert these orders.

Your batch of Yahoo orders are imported into temporary files, counted and can be displayed, modified, and corrected.

 

You MUST Enter /Re-Enter your  to make  active.

 

 


Top, Next

 

(5) The new batch of Yahoo Orders will be converted into Orders and Invoices depending on the preference defaults displayed in.

Text Box: These ‘Preferences’ are established by management and seldom need to be, but may be, changed here.

Top, Next 


Top, Next 

II. Order validation before creating the Orders & Invoices:

i) What have I just imported?

  

 

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?

 

 Top, Next 

III. Conversion Preferences

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?

 

Top, Next 

 

4. Yahoo export and download your customer orders.

A. Log onto your Yahoo® store and select

Top, Next 

 

B. Export the desired orders (by clicking Export).

I. Save your download to your standard directory

Top, Next 

 

5. Import details

A. Wizard realizes your files are ready:

I. As soon as you’ve down loaded ‘Orders/ Items/ Options’ from Yahoo, the text changes to the following:

II. Check Display and click ‘Import’

III. Your data is imported, examined and displayed for validation.

 

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 wrong company, you MUST re-enter your Company prefix  before the

button becomes active.

 

  

Top, Next 

IV. Duplicate Import

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 wrong company or something and this makes you aware of and allows you to fix potential problems.

To help troubleshoot anything found do the following:

(1) Double click to list all orders and invoices in YIC.

You can use Find (Ctrl+F) to see when these orders were previously imported and the status of their lines.

Top, Next 

V. Bad freight / ‘Ship Via’

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.

i) Double click to define these Freight Carrier services.

 

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’.

 Top, Next 

B. Set your preferences

I. Credit Card Processing, Drop Ship, Invoice/Ship immediately?

 

 

Text Box: These general rules are established by management but can be overridden during import. 
They affect major decisions controlling what happens to your new orders being processed.

 Top, Next 

6. Processing details:

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.

B. Click  when available.

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.

 Top, Next 

C. Correct problems as they occur.

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 PO recommendations), or invalid items numbers. EG ‘None’ or an item you added to the web store but haven’t yet added to YIC.

I. Invalid item codes from Yahoo

i) The item ‘None’ is invalid.

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.

  Top, Next 

 

ii) Locate the correct item code by selecting it from the drop down.

 Top, Next 

iii) Then click DONE.

iv) Finding an item:

New items shouldn’t actually use the ‘Yahoo ID’ so you may not find it.

(1) Filtering by Supplier, Category or Sub-Category

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.

 Top, Next 

v) Pick a supplier and category

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:

 Top, Next 

(1) If this is truly a new item:

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 .

(2) Your orders are displayed as they are imported

 

 Top, Next 

D. When done processing, a recap of this batch is displayed.

I. Clicking the  button provides the following report:

 Top, Next 

E. ‘Ready to Invoice’ customer orders are displayed.

 

 Top