Catalog Merge from SQL Database

  • Thread starter Graphic Resource Systems
  • Start date
G

Graphic Resource Systems

I am trying to make a catalog for my business. I have successfully gotten
the information out of our SQL Database using a Catalog Merge. My problem is
as follows, we sell printing papers for wide format printers, the paper we
sell have the same descriptions but have different sizes, part numbers, and
pricing, i.e. Paper 1 comes in 36"x100' 42"x100' but both have the same
descriptions as they have the same face surface. When I do the catalog merge
I get the description for each and every product and it makes the catalog
about twice as long. I wanted to have a description set up for a group of
papers and then have the individual different sizes, part numbers, and
pricing in a table under the description. I have tried to make an example
below; this is what I want to have happen. Please let me know if this is
possible.


Paper 1 is a Coated Matte Print Paper is a versatile media economically
priced for short-term indoor applications. It is lightweight, easy to fold,
and boasts an ink-receiving coating that delivers truly brilliant colors.

Size Part Number Price
36"x100' 1051028 $100.00
42"x100' 8980096 $116.67
50"x100' 8518615 $139.00
 
E

Ed Bennett

Graphic said:
I have tried to make an example below; this is what I want to have
happen. Please let me know if this is possible.


Paper 1 is a Coated Matte Print Paper is a versatile media
economically priced for short-term indoor applications. It is
lightweight, easy to fold, and boasts an ink-receiving coating that
delivers truly brilliant colors.

Size Part Number Price 36"x100'
1051028 $100.00 42"x100' 8980096
$116.67 50"x100' 8518615 $139.00

Catalog Merge is not able to do this; either it would need to be done
manually or you'd need to hire a developer/consultant-type to write an
Automation-based solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top