Product + retreive though PHP

[mradziwilko]

I need to make a product, that has Feilds 3 of them, Name, Location, URL, when a person buys this it is stored in the database, then retreived though php (Output php, though XML) into a file, whats the easiest way or what table (Or how should i get this data)?

[brian!]

13 hours ago, mradziwilko said:

I need to make a product, that has Feilds 3 of them, Name, Location, URL, when a person buys this it is stored in the database, then retrieved though php (Output php, though XML) into a file, what's the easiest way or what table (Or how should i get this data)?

the built-in way would be to use Product Custom Fields...

Quote

Products you create can also have custom fields added to them which are then shown to the user during the order process. This allows you to collect further information specific to an individual product. These are set when configuring a product in Setup > Products/Services > Products/Services > Edit > Custom Fields tab.

... and the details will be stored in tblcustomfields and tblcustomfieldsvalues.

[mradziwilko]

OK, while waiting for this thread i saw the API, but every so often more then i like it keeps saying " Unable to connect: 6 - Could not resolve: ***.com (Could not contact DNS servers)" but everything else works.