We use the Sitefinity API. Here is the documentation on how to import data and images from Sitefinity.
Yes, you can do this and more with the "Override and Supplementary Data" capability, documented here. Here are the available features:
- 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
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, does 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.
You can use Private Data Editor to recategorize your products. There is a Catalog-on-Demand setting that prevents the Sitefinity import from overwriting your categories.
Yes. Catalog-on-Demand automatically handles all the sizing, positioning, and text wrap issues associated with having different shape images for different products.
Sitefinity offers an API that is well-suited for importing product data into Catalog-on-Demand.
- Create an administrator user. We suggest naming it "catalogondemand". Use this email address: firstname.lastname@example.org.
- Choose any password. You will be entering the password in Part II.
- Sign into Catalog-on-Demand (registration is free if you have not already done so).
- Click on Account (top menu). Go to the Automated Data Import Setup section.
- Under Import type, select Sitefinity Ecommerce Import.
- Enter the URL for your site.
- Enter the user ID (e.g., catalogondemand).
- Enter the password for this user.
- For the moment, leave all the options at their defaults.
- Choose at least one day of the week. We recommend you choose every day of the week.
- Click Save Changes.
- Click Import Now.
- After a few minutes, click on History (in the Data Import section). You may need to click refresh, because the import does not start for about 2 or 3 minutes.
- When the import is complete, click on Download Report.
- Review the report for errors. If you have any questions or issues, please contact support.
- If all is well, then you are ready to publish!
Catalog-on-Demand offers several options for importing data from your Sitefinity ecommerce database.
- Get special price / Get actual price — You can check one of these boxes, or none. You cannot check both. If neither are checked, you will get the list (regular) price. If you check Get special price, you will get the sale price as an additional attribute. If you check Get actual price, you will get the sale price if it is in effect, or the list price a sale price is not in effect..
- Include short description — Check this if you want to include Sitefinity's built-in description in your publications.
- Include custom fields into description — If you want to use a custom description field in your publications, check this box. Enter the name of the custom field (e.g., ExtraDescription).
- Ignore HTML tables — If checked, then any HTML tables in your 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 all styles — This is useful if you have font formatting in your HTML that you do not want to appear in your print catalog.
- Import categorization from Departments/Categories — Sitefinity offers two ways to classify your products. Choose which one you want to use for your print publications.
- Include custom fields — Enter the fields you want imported as product attributes. Separate the fields with a comma (e.g., Features,UOM). They will appear as label/value pairs in your catalog. You will be able to suppress these attributes if you want.
- Tiered Pricing Options — Sitefinity offers tiered pricing. If you want to publish the tiered prices, enter the labels you want to appear in your print publications. You can enter labels for three columns: quantity, price, and savings.