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.”
Now look for “Export Products to Flat File” and click on it.
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.
This will move all the selected ASM fields over to the export file.
Now scroll up and enter your email address into the email field. Then select the "Export" button.
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.|
|Multiple Box Points:||MULTIPLE_BOX_POINTS|
|Options Weight Points:||OPTIONS_WEIGHT_POINTS|
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.
Once you have imported your information, you will see some of the information will now be populated in these fields.