24/7 Support: 800.608.6482

Get Started

How To Guides

How to Import and Export Product Data Using the Advanced Shipping Module

1. Export Products to Flat File

2. Importing Products from a Flat File

Exporting Products to Flat File

After you install the Advanced Shipping Manager you'll want to export product data to a flat file. To do that, click on “Menu” and then scroll down to “Data Management.”

“Data

Now look for “Export Products to Flat File” and click on it.

“Export

This will bring up the screen below. Scroll down towards the bottom to "Custom Fields". Select all the fields that have an "ASM" (for Advanced Shipping Manager) before it, then click on the "Select" button.

“Export

This will move all the selected ASM fields over to the export file.

“ASM”

Now scroll up and enter your email address into the email field. Then select the "Export" button.

“Email

The spreadsheet below will be emailed to you. You can fill all your product information in and then import it back up through the "Import" section on the same tab.

Product Variable Fields: Export Product Fields Field Description
Dimensions: DIMENSIONS Enter the 3 dimensions of the package. Each dimension should be separated by a space. The order is length, width, height. Please note that an item with dimensions automatically sets the Ship-alone variable to Yes, as there is no mathematical way to combine dimensions.
Free Shipping: FREE_SHIPPING If this is set to Yes, then there will not be a charge for shipping for this item is the free-ship-method is selected by the customer. This allows for example ground to be free, and for air to be charged.
Free Shipping Methods: FREE_SHIPPING_METHODS Exclude this item from getting a site-wide free shipping promotion. Regardless of other items, this item will ALWAYS be charged for shipping – even when the threshold for free shipping has been reached.
Ship Alone: SHIP_ALONE If this item must be shipped alone (cannot have other items in the same package), then set this to Yes. Other items in the same order will be calculated in a separate package.
Flat Ship Rates: FLAT_SHIP_RATES Each shipping method is defined on a separate line with a blank line between methods. The number before the equal sign is the method number, and after the equal sign is the shipping rate. Methods that are not defined will continue to charge by the rule that matches the destination.
Origin Zip: ORIGIN_ZIP Enter the origin zip code of this item. This zip code will be used to calculate the shipping cost of this item. If other items in the cart have a different zip code, then they will be calculated in a separate package.
Number of Boxes: NUMBER_OF_BOXES If a large item requires more than 1 package, specify here the number of packages that this item requires. If this is used, all boxes will be calculated using the ship alone rule. For example, there won't be other items in one of the multiple packages of this item.
Multi Box Weights: MULTI_BOX_WEIGHTS If this item has more than 1 box, then enter the weight of each box here separated by a space.
Multi Box Dimensions: MULTI_BOX_DIMENSIONS If this item has more than 1 box, then enter the dimensions of each box here. Each box goes on a separate line with a blank line between each. Put a space between each dimension for each box.
Invalid Ship Methods: INVALID_SHIP_METHODS In some cases, certain shipping methods cannot be used with certain items. In this variable, enter the number of each shipping method that cannot be used with this item. Separate each method number with a space.
Markup: MARKUP Markup or down shipping for a specific item. The value is a flat dollar amount.
Global Free Ship Exclusion Exclude States: GLOBAL_FREE_SHIP_EXCLUSIONEXCLUDE_STATES Exclude this item from getting a site-wide free shipping promotion. Regardless of other items, this item will ALWAYS be charged for shipping – even when the threshold for free shipping has been reached.
Exclude Countries: EXCLUDE_COUNTRIES Exclude this item from being shipped to certain countries. Separate each country abbreviation with a space.
Exclude States: EXCLUDE_STATES Exclude this item from being shipped to certain states. Separate each state abbreviation with a space.
Optional Add-Ons
Item Points: ITEM_POINTS
Multiple Box Points: MULTIPLE_BOX_POINTS
Bundled Quantity: BUNDLED_QUANTITY
Bundled Weight: BUNDLED_WEIGHT
Bundled Dimensions: BUNDLED_DIMENSIONS
Bundled Points: BUNDLED_POINTS
Process Time: PROCESS_TIME
Hazmat: HAZMAT
Options Weight Points: OPTIONS_WEIGHT_POINTS

Importing Products from a Flat File

“Spreadsheet”

If you have a lot of products and multiple people working on the site regularly, it might be best to only upload the fields you need for this module, which are the PRODUCT_CODE and the fields that were downloaded for Advanced Shipping Manager.

“Spreadsheet”

Once you have imported your information, you will see some of the information will now be populated in these fields.

“Import

Looking for Developer Docs?

We have a whole section for that, including: Developer Training Series, Template Language docs, Module Development tutorials and much, much more.

Head to the Developer Section

This website uses cookies to identify visitors, track visitors to our website, store login session information and to remember your user preferences. By continuing to use this site you agree to our use of cookies. Learn More.

This website uses cookies. By continuing to use this site you agree to our use of cookies. Learn More.

Accept

Miva believes that all online businesses should have access to a scalable ecommerce platform that can meet their unique business requirements. Miva offers PCI compliant ecommerce, hosting, and custom website design and development solutions. Miva customers have processed over $100 billion in online sales since 1997.

Copyright © 2016 Miva, Inc - All Rights Reserved   Privacy Policy | Store Policy

Links
Contact Us
Receive Tips & Updates

Copyright © 2017 Miva, Inc - All Rights Reserved

Back To The Top