Maintaining price lists is one of the most labour intensive tasks framers have to date been required to endure. It is also seen by framers as largely unproductive. Since the introduction of the FramR Catalog Import Wizard, framers have discovered that it only takes seconds to completely update their catalogs. The time saved can be spent on more productive tasks. Framers now prefer suppliers who can provide data in this format as it makes them more productive.
There are also significant advantages for you as a supplier. Often framers are reluctant to accept new corner samples as they simply do not have time to price them. Or if the framer does accept the samples, they do not go on display until the framer gets around to pricing them ... eventually.
If you provide your catalog in FramR format, you can ensure your framers always have up-to-date prices. Framers will have the latest price list before you walk in through the door with your new samples. You can even offer to put the new samples on display for them, ensuring your products are immediately available for sale.
FramR is able to import moulding, matboard and items catalogs from a CSV file. Most suppliers can easily provide their data in Microsoft Excel format, but not all framers have Microsoft Excel. We therefore chose the CSV format because it can be easily created using Microsoft Excel, but does not require Excel on the framer's computer to read it. Moreover, this file format is very small, so it can be distributed by email.
To create a CSV file from Microsoft Excel, click File/Save As, then select CSV (MS-DOS) from the list of available formats. Do not use CSV (Comma delimited) as this can corrupt your data.
You should prepare one CSV file for matboards, one for mouldings and one for items
The CSV file for matboards should include include code, range, description, length, breadth and cost in separate columns. Cost for bulk quantities, if available, can also appear in separate columns.
The CSV file for mouldings should include include code, description, width, rebate width and cost per meter, in separate columns. Chop cost per meter and cost per meter for bulk quantities, if available, can also appear in separate columns.
Each item should appear on a separate line. Suppliers should also take care to ensure there are no commas within the fields. For example, a comma within the description field can make the description field appear as 2 or more separate fields. You can remove commas in Excel by clicking Edit/Replace, replacing commas with nothing.
Suppliers who are unfamiliar with creating these files are invited to contact Framiac for assistance. If you wish, we will also test your files to ensure they do import readily and without errors.
If you wish we will advise Framiac clients that your catalog is ready for import and advise them to contact you for a copy of the files. This will provide you with new sales leads. We are happy to include a short promotional message, such as announcing a new product line, with the mailout for your catalog.