From package to ltl and air freight, worldship shipping software enables you to process shipments easily, remain compliant, and reduce costly errors. Automatic export of tracking from ups worldship to thub. Foreign key relationships can also be defined at this point. The import tracking number feature allows you to import ups tracking numbers from worldship into orders, and automatically change shipment status to shipped. In worldship start the keyed import method if its not already open by clicking worldship importexport data keyed import choose the import from shipworks for keyed import map.
On the ups online connect menu, click connection assistant. To import the addresses using a template with a comma separated format, click download a sample. Next, click on the setup button to launch the ups setup wizard. Then, at the beginning of the shipping day, you place ups worldship in autoimport mode, and simply go about the business of processing packages in the cms manifest. I am in the middle of testing crm 4 for a limited implementation in my organization. Once exported from coresense, import the shipments into ups worldship. Your worldship address book import file cannot contain more than 2,000 entries, which is the maximum limit of the ups. Fill out the agreement completely and fax it to 18888778029. When you click the label button on the manifest windowor scan the barcode for the label buttonif the package is to ship by ups, cms exports the shipping information to an.
Ups provides you with multiple ways to integrate worldship with your business. Click browse, and choose the appropriate file to import. We use platinum shipper which piggybacks off of ups worldship and we set up an keyed import for worldship which in turn makes it work with dazzle. This topic outlines the steps required to integrate the standard edition of seom with ups worldship. Ensure the two mappings are in the create or edit an import or export map window. Choose cmspackagesexport from the box and click export. You can now open ups worldship and the import map will have been recreated. From the ups importexport data menu, select keyed import sg2import. In ups worldship, click on importexport date and choose createedit map.
How to setup ups using default mapping templates acctivate. Importing orders to endicia dazzle general selling. Click on the browse button to locate the worldship backup data file, then click on the next button. Click the importexport data menu, click automatic export after processing shipment. Worldship software provides an easy way to automate your shipping tasks. Importing single order in ups worldship keyed import 1. Then, check that youve read and agree to the ups terms and conditions. Link to ups worldship provides a convenient and easy way to ship with ups without rekeying ebay order details. Click the ups importexport data dropdown menu and select createedit map in the new map area, select export data from worldship select shipment from the dropdown list for map type.
Click odbc login button and enter a username and password combination. Import a file containing addresses, customer orders, or other shipment information, or export shipping history to your internal systems. In this section you will create a new map for exporting commodities. Click import to complete the import process and return to the addresses screen. Any document imported with ups worldship closed will not have processed.
Workdship shipping software if shipping is a critical part of your business, we can relate. In the worldship user guides page, click the download link for the. In addition to performance and security benefits, worldship 2019 provides access to all the latest ups products and services. Once your database is connected and your fields mapped, you will need to select keyed import and from the drop down, select the name of your import map. You can import an address book and manage addresses to simplify entry of recipient address details.
Make sure to select small package shipments as the type of data to import. If you connect to a data file, you can pull complete shipment information one order at a time or as a batch. How to create the shipgear import shortcut button in ups. Ok in the folder ups\wstd\impexp is where theyre stored and depending on what youre doing it might be in a different folder, but mine was in shipment. In ups worldship, automatic export after processing should be enabled before the label is printed in ups. I do a keyed import and use an actual order number. At any rate, the area you need to download the report from amazon is under.
Circuitree export file database that worldship will look at for keyed import. You need to get shipments out as quickly as possible. Click on importexport dataautomatic export after processing shipment, and select more. See the ups worldship documentation or contact coresense support for. Up to 2,000 addresses can be imported from your ups worldship address book directly into your my ups address book. All of the mappings appear to be working as expected, however, the performance when trying to enter a keyed import or automatic export after processed shipment is incredibly slow, sometimes taking as. Link to ups worldships integration within ebay selling manager applications provides a convenient and easy way to ship with ups without rekeying ebay order details. To change the import setting, see change worldship keyed import setting for more information. Enterprise edition users should consult the ups worldship integration enterprise edition topic for instructions. If you dont want to use the keyed import method, you can also use the batch import functionality of worldship to import multiple orders. In shipworks, process shipment as normal home ship orders using provider. Make sure to select small package shipments as the type of data to import use the location that you specified in the circuitree export file for the data file location orders. Allow worldship to recognize a customers order simply by entering or scanning a unique identifier. In ups worldship, open the keyed import window if not already open and enter the order id of the order you want to ship hit enter on your keyboard the fields will populate.
Troubleshooting ups worldship keyed import map missing. One thing that ups requires on packages is the attention field which i have mapped, but information is not always populated in that field. Under commands, choose keyed import, and then click add. Import shipment data using odbc and keyed import to import shipment data using the ups worldship odbc and keyed import features. Highlight countryconstabbreviation ship tocountryterritory and click disconnect. Slow performance when integrating ups worldship with. Designed for professional shippers, link to ups worldship application helps streamline your shipping processes while providing access to upss complete list of shipping services ranging from small package to freight. Worldship integration gives you several options for getting the information required to generate shipping labels. Import shipment data using the sample order import 1 map. Items are automatically updated with shipment status and tracking numbers to improve customer service and keep your toprated seller status. The following are options within the ups worldship software that make use of the above automation methods.
Worldship xml auto import process the xml auto import feature allows worldship to import and process shipments in an xmlformatted file. Enter the weight or have a connected scale do that for you and print the shipping label. On the tools drop down menu, select profile editor. Click on the check box next to the finish moving worldship data option to restore the worldship database from your previous computer. The windowsbased software is available in 20 languages and more than 140 origin countries or territories. Can i import just name, addresses and zip codes under a specific profile to keep the other variables constant. In worldship, the function to extract order information from sage 100 erp is called keyed import. To use this method, shipgear must be set up to use a worldship keyed import setting of item id. Ill be happy to post the code i came up with shortly as i am still working on the next step which is having the ups shipment data written back into navision. Transfer exportimport commodities in ups worldship 11. The following screens from the ups worldship program will illustrate the steps needed to export shipping information screens may be slightly different due to different versions of the software. From the list of available shipping providers, select ups worldship. How do i download my ebay order file to be used by link to ups worldship.
Use the following document to enable keyed import by using the import export wizard in ups worldship worldship import shipment data. Now that the odbc driver has been configured, start the ups worldship software and click on the importexport tab. If you dont want to use the keyed import method, you can also use the batch import functionality of worldship to import multiple orders at the. Hi will, it sounds like you will require a customized. Launch ups worldship, inside of ups online worldship, select importexport data from the standard toolbar in the worldship window. Click importexport datakeyed import, and select cmspackages if its on the list. Select one alabama alaska alberta arizona arkansas british columbia california colorado connecticut delaware district of columbia florida georgia hawaii idaho illinois indiana iowa kansas kentucky. Keyed import mapping to a data source so a shipment record can be pulled by unique identifier and populate on the shipping screen. Select your profile from the profile name drop down menu and click the reference tab. Click on importexport dataautomatic export during endofday, and select off. Task scheduler and disable the xtentodownload job task. Create shipping labels with worldship and ecommerce. If label is already printed in ups then you have to do end of day in ups worldship and then export tracking to thub using importexport batch export thubupsexport select date range. Enter the order number you want to ship and hit the enter key.
Processing ups worldship shipments in batches or with. Part of this implementation demands an export of order data from crm to be imported into ups worldship. Or the mapping file you use at the bottom of the screen you will see a list of mappings. We are building an integration between ups worldship and oracle applications. Allow worldship to recognize a customers order simply by. Use the following document to enable keyed import by using the importexport wizard in ups worldship. When shipments are processed, an output file is created, and it contains the. Ups advisory and technical support services agreement. Inhouse, web, subscription programs, etc this filemaker database is talking to ups worldship through odbc and with a keyed import from worldship. The connection assistant select import or export step 1 of 5 window appears. Next, we have to create the import map inside of worldship, so that the correct fields in the table are translated to the correct fields in worldship. The following screens from the ups worldship program will illustrate the steps needed to import addresses screens may be slightly different due to different versions of the software. How to move ups worldship to a new computer your business.
To import shipment data using the ups worldship odbc and. This can be performed by performing a batch import, or using the keyed import functionality. Use the location that you specified in the circuitree export file for the data file location orders. It stays open until you close it or exit worldship. Solved ups worldship import maps disappear spiceworks. If you do not see sg2import on the ups connect menu, select more and then select sg2import from the list. If you have previously created an export map, you can skip this section. These should never be changed otherwise link will be broken between the two system and the integration will no longer work. I have two profiles set up defining package weight, ups service, bill transportation, package type, and reference numbers. If you are upgrading your operating system or are moving your worldship installation to a new computer, we recommend you install the latest version of worldship. I connect each nav field to its corresponding worldship field. Orders will be accessed using a feature called keyed import. To import shipment data using the importexport wizard and keyed import. In order to import addresses an import map must be created through an odbc connection.