Auction Logic

Import AuctionLogic items into UPS Worldship

For ease of setup and use, AuctionLogic exports into a csv file compatible with the UPS Sample Order Import 1 Map that is already created in Worldship.

Just download the export file from AuctionLogic, name it worldship.csv, and place the file in the “ImpExp\AcctPkgs\Sample Order Import 1″ folder inside the folder where Worldship is intalled.
On most Windows systems with a default Worldship install, it will be at:
 

C:\UPS\WSTD\ImpExp\AcctPkgs\Sample Order Import 1\
or
C:\UPS\UOWS\ImpExp\AcctPkgs\Sample Order Import 1\

For step by step instructions for importing AuctionLogic data into Worldship, download the UPS “Import Shipment Data Using the Sample Order Import 1 Map” help document

Export shipments from UPS Worldship for import to AuctionLogic

First you must create the export map in Worldship that will export your shipment data in the csv format that AuctionLogic can read.

Once the export map is created, you can export your shipment data to a csv file that can be uploaded into AuctionLogic to update your shipping status, cost, and tracking numbers.

Setup an export to csv map

Go to the ‘Import/Export Data’ menu
Choose ‘Create/Edit Map’
Under ‘New Map’ select ‘Export data from Worldship’
Check the Export CSV box
From the drop down menu, select ‘Shipment’
Enter ‘Export2AuctionSound’ in the ‘Name’ field
Click the ‘Create’ button

This brings up the “Edit ‘Export2AuctionSound’ export to CSV map” window

Click the ‘Shipment Information’ tab Select each of the following and click the ‘Add’ button, in this order

• Lead Tracking Number
• Billing Option
• Collection Date
• Total Shipment and Handling Published Charge

Click the ‘Package’ tab Select each of the following and click the ‘Add’ button, in this order

• Void Indicator
• Reference 1
• Reference 2
• Reference 3

Select the ‘Overwrite existing file’ option
Ensure that ‘Comma’ is selected under the ‘Field Delimiter’ area

Click the ‘Define CSV File Name’ button and choose a filename and location you will remember. (This is the file you will import in to AuctionSound)

Click ‘OK’

The window will close, and you should see the ‘Export2AuctionSound’ highlighted under the ‘Existing Maps’ area.

Click ‘OK’

Export shipping data from Worldship

Go to the ‘Import/Export Data’ menu
Choose ‘Batch Export…’
Select the ‘Export2AuctionSound’ map
Choose the date range you wish to export. (eg, ‘All records on or after’ todays date)
Click ‘Next’

The ‘Import/Export’ Preview window will appear telling you how many shipments will be exported.
Click ‘Next’

The ‘Import/Export’ Summary window will appear telling you how many shipments were exported.
Click ‘Save’

The export file will now be saved and can be imported to AuctionLogic

(Instructions Courtesy the Engineers at AuctionSound)