Using OrderAnywhere, pull price from database and display

[Mitchel]

Hi:

I am using the OrderAnywhere functionality and was wondering if there was a way to pull a price from the database so I can display it on my pages?

I was going to use a .js file and just store the variables in there and display them were needed...it does work, but I thought it would be even better to get the prices directly from the database so my client only had to go to one place to make price changes.

Thanks,

Mitch

[robm]

Mitch,

There is no easy way to do this using Order Anywhere. Your two options would be:

1. Use the XML download feature of ShopSite to periodically download product information to a separate database like MySQL, and then dynamically output the price using php for example.

2. Create a special custom product template that has a moreinfo section that *only* outputs the price:
[-- PRODUCT.Price --]
and have all products assigned to one page, and make sure each will create a moreinfo page with a unique filename, and then use an SSI, PHP, or JS include to pull the price from these moreinfo files for each product.