Don't Cross Contaminate Data

This is a fairly important point so I thought I would write a whole article about it. I've said it time and time again in other posts so I thought I would clarify exactly what cross contamination in product data actually is. Cross contamination means you are not supplying product data in the right fields.

Read more: Don't Cross Contaminate Data

How to Display Origination

Origination, extra charges and fees in the promotional products industry complicate ordering. Life would be easier if they just did not exist! It should all be worked out internally and the customer then given an all in price. This is how ProMart 2.0 works. We combine all the costs and display an easy single unit price.

Read more: How to Display Origination

How to Setup Lead Times

Most of the data we receive usually has the lead time shown in one column.

This is ok for display purposes, and can be easily imported into a standard alphanumeric data field, however.  If we want to go beyond a standard data field, and use the data as a searchable field then we need to look at separating this out.

 As a standard we should always try and stick to using one unit of measure.  I'm going to stick my neck out here and say it should always be working days. Not Weeks and Not Months.

Read more: How to Setup Lead Times

How to Setup Prices and Price Breaks

Setting up your pricing correctly can make or break the quality level of your product data. Having done some research on enquiries at several suppliers and distributors we have worked out that 93% of all enquiries could be quoted instantly if we had a minimum of 5 price breaks.  This is from data collected over a 6 month period. As with all the product data formats we have allowed for scalability.

Read more: How to Setup Prices and Price Breaks

How to Setup Print Areas

I hope you like the image. (It's a Print Area!)

On top of supplying PDF proof templates, it can be very helpful to have the print areas supplied in a datasheet.  

Whilst most are usually a rectangular size it's a good idea to have a notes column, then you can enter special information such as "Diameter" or "See Visual" for more unusual print areas.  

It's also a good idea to list the print methods within this part of your datasheet.

Read more: How to Setup Print Areas

How to Setup Product Colours

The format for your data sheet should be each colour separated by a comma.  This is the format that google shopping uses and is generally an excepted format. ProMart 2.0 websites use a directory scanner to load the images into the database. However we accept that not all suppliers will have separate images for each colour of the product they can supply.

Read more: How to Setup Product Colours

How to Setup Specifications & Proofs

The best way to setup your visuals is in a CSV file with the name of the PDF file in it.  Use the product code to name the PDF file. The full product code, not an abbreviated version.

Why is this the best way to display the data?

Because then this data can be used to upload to a website or referenced in another database. The files would then be batch renamed to new product codes and they would all be uploaded to a directory that then automatically displays them on a website on the corresponding product page.

Read more: How to Setup Specifications & Proofs

  • 1
  • 2

Copyright © 2019 PromoNet Ltd | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 08456645 - Registered for VAT: No GB170189410