3M Order Center Functionality - Steps to Upload Orders Directly to 3M

Modified on 05/02/2011 11:10 AM by Jason Greenleaf — Categorized as: Guide, Procedures, Public, Support


Step 1:



Electronically download/export your order out of your system into Excel. Format should include just two columns, Product number (product number without any prefixes like MMM or 3M) and quantity you wish to order. Note: Prior to placing your first order, contact your CSR to verify which billing unit you will be using. (e.g. case or box) Also, you will need to be consistant in your ordering pattern and not bounce between cases and eachs for your quanitites. But your CSR can assist you on this. Here is an example of what it might look like in Excel…

Image



Step 2:



Click on File, and then go down to Save As. For file name, enter the name of order you want to save, and under file type select comma delimited or Tab delimited. Note: There is a limit of 199 items per upload. If you have more that on your order, save your order into two files and upload both one after the other on the same order.

Sample of a Tab delimited file:

Image



Sample of a Comma delimited file:

Image



Step 3:



Sign onto 3M Order Center ( www.3M.com/secure ).

Step 4:



Click on Order Center in the left hand navigation.

Step 5:



If you have multiple ship-to or charge to locations, click on change at the top of the screen, and select the location you want to ship or charge to.

Step 6:



Click on Order FileUpload in the left hand navigation.

Step 7:



Click on the Browse button to find the order you just saved on your system.

Step 8:



Select the type of file you saved. (It is best to use Tab or Comma delimited)

Step 9:



Select the format you used to save your file: Were the columns listed as Product number, Quantity or Quantity, Part Number.

Step 10:



Select the Product ID of Customer Part Number

Step 11:



You are now ready to upload your order. Click on the Submit button.

Step 12:



When the items are entered into your shopping cart, any errors in quantity,product number, etc. will be noted for you. In addition, the system will highlight your order level pricing to ensure that you are getting the proper price breaks, etc. Note: If you cannot enter a product into your order that you think should be correct, submit all the other items to your shopping cart and go to the Non-standard Item link in the left-hand navigation and enter the product number quantity. Then click on Add to cart. Your CSR will correct the item in the system and you should be able to upload it the next time you enter an order.

Step 13: Check Out



If for any reason you NEED to send a note to your CSR regarding the order, enter it on the same screen that you enter your PO number. However, only enter a note if this is critical. This will stop the order at the CSR desk, and not flow directly to the warehouse.

Step 14:



Submit the order and you are done!

Here is an example of the Order File Upload page in 3M Order Center:

Image

If you have additional questions, please call your CSR or Celeste Hughes at 651-736- 2236 (cmhughes@mmm.com)