Uploading a Custom Range – Gun Web Systems Support Centre

Procedure for creating a Custom MPS Datafile

1. Open the blank MPS Format Datafile (Excel Spreadsheet) and save your file.

2. Create a unique supplier code for your range. My example supplier name is The Stress Shape Factory, so I will use STRESS as the Supplier Code.

Column B and C are the Item Code. These columns have to be the same, and make sure the item code has no spaces, otherwise it will cause an error.
Column D is the Item name. Please note people can use the search bar on your website to find this product so it's best to keep it simple and obvious. Example if it's a Polo, make sure Polo is in the item name.

3. Column E is the Long Description. You want to have the product information here, such as a description, sizes, colours, print options, print areas etc. If the product includes a print, you need to specify in this cell what it includes.

Column F and G remain BLANK. Regardless of their column headings, these columns are not used.

4. Columns H through to W are the Quantity and Pricing columns where you enter the COST prices EX GST.

See below how Qty1 starts off with the minimum quantity, followed by its cost price.

Any pricing cells not used, are to have a 0 placed inside, the datafile wont load without each pricing cell being filled with a value.

Column X to remain BLANK.

5. Column Y is the Sub Category column. Enter the sub category you want your product to sit under. Please note that for your item to sit under one of our MPS sub categories it must be spelt the same way. For example we have used one of our own categories called Anti Stress Items, type is as shown in your left hand menu and it will appear under that category.

If you want a NEW sub category, enter in what you want in that column.

6. Column Z and AA are related to eachother. If the product you have entered is a BLANK product, meaning its going to select the sub decorations from your sub decoration file in your system, you need to put a 0 in the isprinted column and the corresponding Main Decoration Code to suit that item. In this case, we have selected PAD for Pad Print.

If you want multiple decorations, seperate the Main Decoration code with a comma like this: PAD,STK,DIGTRANS

If the product included a 1 colour pad print for example in the price you entered, then you need to put a 1 in the isprinted column (meaning 1 colour print) and then PRINTINC in the printtype column so the system knows it's a print included item.

Column AB is BLANK

7. Column AC is the Image File name area, where you type in the matching image file name.

Like the item code, the file name must have no spaces, or else it will trigger an error. For our example, we can see how image name is called PP607_Smiley.jpg. It is important to remember that the images you use must be in a .jpg format.

So we enter this exactly as its spelt, same use of capitals and lower case so the system can identify the image.

8. Save your datafile and open your website and log in using your User credentials.

9. Go to Add Suppliers

10. You need to enter in the Supplier code (Found in Column A word for word), the supplier name and an email address.
(can be your own email address)

11. Scroll down the bottom and click Local Image Path. This is important as its telling the system to look at your local folders for images, not our mypromosource library.
Then hit Submit.

12. On the same page, scroll down and click Set/Edit Supplier Margin

13. Enter the mark up rate you want to use and click Submit
We have used 1.5 which is 50% markup.

14. Go to the Admin Panel and go down the bottom to View Range Permissions.
Go into Not Logged in User, and Tick your range so it shows, and click Submit.
Then go into Clients, and Tick your range so it shows, and click Submit.
Then go into Users , and Tick your range so it shows, and click Submit.

15. *Important* Please log out and log back in

16. Now when you are logged back in, go to Upload Datafile. Find your datafile and upload.

Click Validate Uploaded File Data. If your datafile is done incorrectly, this is the part where the system will tell you whats wrong with the file.

Then click Save WITH Category and Image Updates

Then click no

It will then show you the successful message the file was loaded.

17. Go back to the Admin Panel and go to Bulk Image Upload or Individual Image Upload, depending on how many you have.

Upload your images. Please note they must be 400x400 pixels wide (square shaped). To bulk resize images, see our tutorial here: Resizing Images Tutorial.

18. Check your range to see how it turned out by going to your Range list page. If you do not have one showing, use the bold part in the URL below and paste it onto your website url starting with the /promo so it will take you to the range list page.