from

MAGENTO

Magento-print-catalogs

Create Print Catalogs
from Magento

to

PDF CATALOGS

9 Reasons Why Content From Magento
Sites Works Well for Print Catalogs
Download this illustrated white paper to find out why your Magento
content is well-suited to both web and print.
CLOUD-BASED PRINT SOLUTIONS FOR MAGENTO

Make PDF Catalogs From Magento

  • Make catalogs for every purpose: events, seasons, segments, etc.
  • Use the same content as your online store — including HTML, variants & more
  • Choice of dynamic or grid layouts, with many options
  • Brand with your colors, logo, & artwork
Read more

Auto-Update PDF Catalogs On Your Magento Site

  • Always Fresh® means catalogs are updated every night
  • Create a link to your site one time — the link remains the same
  • Post an Always Fresh catalog or brochure for every category
Read more

PDF for Every Product Page On Your Magento Site

  • Creates a PDF for every product on your Magento site — updated nightly
  • Instantly downloadable
  • Uses your artwork & colors
  • Free up to 1000 product families
Read more

Lite Edition for Sales Reps & Dealers

  • For sales reps, dealers, distributors, etc.
  • They select the template & products —  you control the design and content
  • Perfect for 1:1 sales, wish list reminders, abandoned cart follow-ups, including with shipments, trade show handouts
Read more

Flexible Job File (FJF) for Batch Processing

  • Run publications with no human intervention
  • Launch jobs with any configuration and any combination of products
  • Generate Job Files with any tool, or from any system (CRM, etc.)
Read more

MAGENTO / CATALOG-ON-DEMAND FAQ

Q: How do I integrate Catalog-on-Demand with Magento?

Q: Do you have an alternative to the extension?

Q: Is it possible to make the product description or image in my print catalogs different than what is on our Magento site?

Q: Are Magento attributes supported?

Q: I have product attributes in my Magento site that I do not want to appear in my print catalogs. Can those be hidden?

Q: For some publications (such as niche catalogs) I want to be able to override attribute values and prices. Is this possible?

Q: I have hidden custom fields in my Magento database. Can these be published?

Q: Is there a way to automatically strip out, replace, or otherwise change content before publishing?

Q: I have extensive formatting and HTML in my product descriptions. How is this handled?

Q: How are Magento's grouped products and attributes handled?

Q: My site has multiple Magento stores. Is that supported?

Q: How can I make the product categories in my print catalogs different than in my Magento site?

Q: Is it possible to publish the Magento special price?

Q: We are using Magento's group price feature to manage prices for different customer segments. Can we use price groups for custom print catalogs?

Q: The price in my catalogs needs to reflect taxes. Is that possible?

Q: I will be managing my product data in Catalog-on-Demand. All I want to retrieve from Magento is the product price. Is that feasible?

Q: I want to use the Magento short description for print publishing purposes. Is that feasible?

Q: The product images on my site vary in size and shape. Can I still use them for print catalogs?

Q: I have multiple images per product on my Magento site. For publishing purposes, can I use an image that is not the same as the first image on Magento?

Q: For some product groups I have images at the associated (child) product level. It is important that these images be published, as well as the image at the product level. Is that possible?

Q: Where will I find my Magento store view code?


Q: How do I integrate Catalog-on-Demand with Magento?

A: The most common way to install the extension called Catalog-on-Demand for Magento. We recommend you try this first. Here is the documentation on how to import data and images from Magento using the extension.

Return to Top

Q: Do you have an alternative to the extension?

A: Yes, because the extension is not compatible with every Magento site. For these situations, we offer a script-based approach as an alternative. It offers exactly the same functionality as the extension. Here is the documentation on how to import data and images from Magento using the script approach. Again, there is no difference between the functionality of the extension and the script.

Return to Top

Q: Is it possible to make the product description or image in my print catalogs different than what is on our Magento site?

A: You can use the Private Data Editor (PDE) to change product data. This includes the description, images, and attributes. If you do this, you will want to use the Locked Product feature, which prevents your edited data from being overwritten by the next import.

Return to Top

Q: Are Magento attributes supported?

A: Yes, you can publish all attributes, including Magento attribute sets.

Return to Top

Q: I have product attributes in my Magento site that I do not want to appear in my print catalogs. Can those be hidden?

A: Yes, you can easily hide any attribute in the Catalog-on-Demand configuration.

Return to Top

Q: For some publications (such as niche catalogs) I want to be able to override attribute values and prices. Is this possible?

A: Yes, you can do this and more with the "Override and Supplementary Data" capability, documented here.

  • Price overrides — Publish a price that is different than the price contained in your database
  • SKU number override — Publish with a SKU number that is different than the SKU numbers in your database
  • Attribute value override — Publish attribute values that are different than the attribute values in your database
  • Attribute supplements — Publish attribute labels and values that are in addition to what you have in your database

Return to Top

Q: I have hidden custom fields in my Magento database. Can these be published?

A: Yes, you can designate which hidden custom fields that you want imported and made available for publishing.

Return to Top

Q: Is there a way to automatically strip out, replace, or otherwise change content before publishing?

A: Yes, by using Catalog-on-Demand Plug-Ins. This is a powerful capability to apply JavaScript in just about any way you can imagine to transform your content for publishing. You might use it to publish or suppress prices, combine attributes in a separate field, pull data from another source, or almost anything else. You can create your own Plug-Ins, or we can make them for you.

Return to Top

Q: I have extensive formatting and HTML in my product descriptions. How is this handled?

A: Catalog-on-Demand supports simple HTML for print publications, such as bullets and some styling. Other HTML, such as complicated embedded tables or extensive styling, do not transfer well from web to print. Such HTML may be easily stripped out with simple checkboxes.

In addition, Plug-Ins can be created to handle just about any other clean up or formatting replacement that you can imagine.

Return to Top

Q: How are Magento's grouped products and attributes handled?

A: Grouped product attributes are presented in tables. Each attribute gets its own column. The width of each table column is computed for best fit (or you can specify the widths). You can also rename the attribute labels for publishing.

Return to Top

Q: My site has multiple Magento stores. Is that supported?

A: Yes, you specify which store you want imported when you are setting up Catalog-on-Demand. If you have additional stores solely for purposes of multiple languages, please contact us about a discount for additional languages.

Return to Top

Q: How can I make the product categories in my print catalogs different than in my Magento site?

A: You can use Private Data Editor to recategorize your products. There is a Catalog-on-Demand setting that prevents the Magento import from overwriting your categories.

Return to Top

Q: Is it possible to publish the Magento special price?

A: Yes, the Magento special price can be imported either in addition, or instead of the regular price.

Return to Top

Q: We are using Magento's group price feature to manage prices for different customer segments. Can we use price groups for custom print catalogs?

A: Yes, you can specify which price group you wish to use for any publication.

Return to Top

Q: The price in my catalogs needs to reflect taxes. Is that possible?

A: Yes, there is a setting to pull the Magento price that includes taxes.

Return to Top

Q: I will be managing my product data in Catalog-on-Demand. All I want to retrieve from Magento is the product price. Is that feasible?

A: Yes, there is a setting to retrieve prices only.

Return to Top

Q: I want to use the Magento short description for print publishing purposes. Is that feasible?

A: Yes, you can use either the Magento short or long description for publishing, or both.

Return to Top

Q: The product images on my site vary in size and shape. Can I still use them for print catalogs?

A: Yes. Catalog-on-Demand automatically handles all the sizing, positioning, and text wrap issues associated with having different shape images for different products.

Return to Top

Q: I have multiple images per product on my Magento site. For publishing purposes, can I use an image that is not the same as the first image on Magento?

A: Yes. At publish time, you can choose which image you want to appear with the product. Also, some some of the layout styles support multiple images per product. For these styles, you can choose at publish time which combination of images will appear with each product.

Return to Top

Q: For some product groups I have images at the associated (child) product level. It is important that these images be published, as well as the image at the product level. Is that possible?

A: Yes, if you have images at the child product level, they will automatically be published. If you don't want them published, there is a setting to not import the associated (child) product images.

Return to Top

Q: Where will I find my Magento store view code?

A: If you have multiple stores, you'll need to tell Catalog-on-Demand which store to pull data from. Here are instructions for finding the store view code:

  • (1) Log into your Magento administrator back end.
  • (2) Click on System > Manage Stores
  • (3) Look in the Store View Name column (this is the 3rd column)
  • (4) Click on the Store View Name that you want.
  • (5) You will see the value of the Code. It is case-sensitive.
  • Return to Top

How to Automatically Import Data from Magento into Catalog-on-Demand Using the Extension

Part I: Magento extension setup

  1. Install the latest version of the Magento Extension for Catalog-on-Demand, available here.
  2. IMPORTANT: Log out of the Magento Admin Panel, then log back in.
  3. Enter a password via System > Configuration > Catalog-on-Demand configuration. You can enter any password you want. You will use it again in Part II.

If you have problems installing the Magento extension, please try using our script approach instead. It works exactly the same as the extension. Please contact us if you have problems.

Part II: Catalog-on-Demand setup

Sign in to Catalog-on-Demand (registration is free).
Go to Account > Data Import Setup.

  1. For Import type, choose Magento import
  2. Enter the URL for your Magento site
  3. Set Import Mechanism to "Extension"
  4. Enter the password from above into "Secret key"
  5. Enter the store code if you have multiple stores (see the FAQ about Magento store codes)
  6. Click Create Data Import Setup
  7. Click the Test button
  8. If you have error messages and cannot troubleshoot the problem, please contact us
  9. If the test is successful, click Import Now
  10. Wait for a couple minutes.
  11. Click Import Now, wait for a couple minutes.
  12. Click History
  13. If the import is successful, a button labeled "Download report" will appear.

You are now ready to start publishing. Please contact us if you have any questions or problems.

Part III: Magento Import Options

Catalog-on-Demand offers several options for importing data from your Magento database.

  • Update prices only — This is important only if you have updated your content in PDE (or via another import), and do not want to override anything except for your prices. If you check this box, only prices will be imported. Other content will not be imported.
  • Get prices from associated products — This is important only if you are using Magento grouped products.
    • Check this box if you want the prices in your print catalog to come from each of the associated products in that group.
    • Do not check this box if you want the price to come from the group product.
  • Include tax in prices — This is important only if you want the price in your print catalog to include taxes. If this box is checked, the price (with taxes) that is displayed on your site will appear in your print catalog.
  • Include short description / Include long description — Magento has two description fields. The short description appears in Magento's list view and Quick Overview. The long description appears in Magento's detail section. Check which descriptions you want to include.
  • Include reviews — Check if you want user reviews to appear after your description.
  • Ignore excluded images — If checked, Magento images that have been checked as "Exclude" will not be imported.
  • Ignore associated product images — If checked, the images linked to the associated products will not be imported.
  • Ignore HTML tables — If checked, then any HTML tables in your Magento product descriptions will not be imported. Sometimes this is necessary if you have complex HTML tables that do not appear correctly in your print catalog.
  • Remove color tags — This is useful if you have color formatting in your HTML that you do not want to appear in your print catalog.
  • Remove font styles — This is useful if you have font formatting in your HTML that you do not want to appear in your print catalog.
  • Ignore all categories — This is useful if want a different hierarchical organization for your products in your print catalog than you have on your Magento site. You can use PDE to change your category hierarchy and if you wish, reassign products. Then be sure to check this box so that the import only updates product data, not the categorization.
  • Ignore top categories — Check if you do not want your top category to appear in the table of contents for your print catalog. For example, if the top category in your Magento database is "Products", you will want to check this box.
  • Override file URL — This is useful if you want your print publications to contain a product name, product image, and/or product description that is different than what you have in your Magento database. A sample override file is here. The file may be either tab-delimited or Excel (Note: If you use Excel, save it in the 97-2003 format). Here are the four columns, which must be in this order:
    • Magento ID: This is the ID shown on the "Manage Products" page in Magento.
    • Product name: This can be up to 100 characters. If blank, the Magento product name will be used
    • Product image: This must be a public URL. If blank, the Magento image will be used. If you want multiple images, separate with the pipe delimiter.
    • Product description: This can be plain text or simple HTML. If blank, the Magento description will be used.
  • Smart Product Grouping — This feature lets you use the Override file to put simple Magento products into a single SKU family for purposes of your print publication. For example, say you offer 5 sizes of a particular product. On your Magento site, each size is a separate simple product. This is fine for your web store, but it is an inefficient use of page space in your print catalog. One solution is to create a product group in Magento. However, you may have business reasons for not wanting to do this on your site. 

    The Override file can handle this grouping problem for you. All you need to do is make sure that each product you want included is given the same product name (second column). For example, if you want products 586, 853, and 1129 included in the same SKU family, you would give them all the same product name. If you want, you can give this SKU family its own image and description. To do so, use the 3rd and 4th columns as described above.

    The system will automatically copy each simple product name to the corresponding SKU description, the product image to the SKU image, the product price to the SKU price, and the product attributes to the SKU attributes (you can use other Catalog-on-Demand features to hide or modify these values if you want).

How to Automatically Import Data from Magento into Catalog-on-Demand Using the Script

If you are having problems with the regular Magento extension, please try this solution. It works exactly the same as the extension.

Part I: Setup the Magento Data Exporter

  1. Download "cod_exporter_for_magento.php" from here to your local computer.
  2. Open the file in any text editor.
  3. In line 4, change the password to something of your choosing. 
  4. Save the file as "cod_exporter_for_magento.php".
  5. Upload this file into the root folder of your Magento installation.

Part II: Catalog-on-Demand Setup

Sign in to Catalog-on-Demand (registration is free).

Go to Account > Data Import Setup.

  1. For Import type, choose Magento import
  2. Enter the URL for your Magento site
  3. Set Import Mechanism to "Script"
  4. Enter the password from Part I, item #3 into "Secret key"
  5. Enter the store code if you have multiple stores (see the FAQ about Magento store codes)
  6. Click Create Data Import Setup
  7. Click the Test button
  8. If you have error messages and cannot troubleshoot the problem, please contact us
  9. If the test is successful, click Import Now
  10. Wait for a couple minutes.
  11. Click Import Now, wait for a couple minutes.
  12. Click History
  13. If the import is successful, a button labeled "Download report" will appear.

You are now ready to start publishing. Please contact us if you have any questions or problems.

Part III: Magento Import Options
(same as for the extension)

 

Search Catalog-on-Demand