Spare fields in Order table?

[tonygg]

Hi

I need to keep track of orders I have reconciled to our payment service provider (Simple Yes/No or -1/0). I was hoping to use a spare field in the order table.

There seem to be a few like:

sUserDefinedPayments
How Find Site
Reason For Purchase
sUserdefinedTax
PO Number
sReferenceNumber

The question is whether SellerDeck uses any of them if they are populated to appear on invoices etc or even worse processes on them. If anyone has experience with this table I would be grateful for a pointer towards the safest one to use?

Many thanks

Tony

[malbro]

Hi

I need to keep track of orders I have reconciled to our payment service provider (Simple Yes/No or -1/0). I was hoping to use a spare field in the order table.

There seem to be a few like:

sUserDefinedPayments
How Find Site
Reason For Purchase
sUserdefinedTax
PO Number
sReferenceNumber

The question is whether SellerDeck uses any of them if they are populated to appear on invoices etc or even worse processes on them. If anyone has experience with this table I would be grateful for a pointer towards the safest one to use?

Many thanks

Tony

Reason for purchase is probably the safest.

[tonygg]

Thank you. I will use that field. I was also thinking about adding my own table that could contain the payment data we get back from our credit card gateway provider but I am not sure how well sellerdeck would play with it.

[malbro]

Thank you. I will use that field. I was also thinking about adding my own table that could contain the payment data we get back from our credit card gateway provider but I am not sure how well sellerdeck would play with it.

I have never tried adding a table to the Sellerdeck database so not sure if it would cause any problems.

I have done this with other databases, namely MySQL, where it does not affect the programs as they do not know anything about the new table, 'Access' may be different and it may cause problems, if you can set up a test site then your could try it.

[Andy@codepath]

You can safely add tables to the database without affecting Sellerdeck. Many of our plug-ins use this method to maintain additional data. Just don't make any adjustments to the original Sellerdeck tables.