Fields in Orders Database

[Chris]

Hi all,

Still working on all the details of our switch to Lexiconn and our
upgrade from Version 4.0 to 6.0 of Shopsite Pro.

We have a separate program/script that takes our Orders database file
(in tab-delimited text format) and converts it into the program we use
for all our inventory/bookkeeping/accounting/order processing, etc. This
script/program identifies the needed information and works with it based
on its position in the fields of the data file. So, any addition or
rearrangement of fields will make it go haywire.

Question: Does anyone here have a list of the specific changes in
fields (additions, deletions, and repositionings) from version 4.0 to
version 6.0. I've noticed at least 2 added ones so far: Coupon, and
Product type. Are there more? Also, can I do anything in the
BackOffice to add or remove these fields (other than opening the
database in Excel once I download and manually deleting)?

BTW, Lexiconn was able to transfer our entire backoffice AND keep our
Order Anywhere links intact. I remain very impressed.

Chris
mlcswoodworking.com

[Chris]

Never mind.....I answered my own question:

Version 4 has 2 fields that my version 6 didn't: (ShipOn) and (Viewed).
These always say "Shipon" and "Viewed" all the way down the column and I
don't even know what they refer to, so they aren't needed (except, of
course, as placeholders).

Version 6 has added the following new fields: Coupon Total, Order Info,
CVV2, E-mail List, and Product Type.

Does anyone know if any of these are removable? For example, if I don't ask
customers for CVV2, does that field get removed?

Chris
mlcswoodworking.com

Chris wrote:

Hi all,

Still working on all the details of our switch to Lexiconn and our
upgrade from Version 4.0 to 6.0 of Shopsite Pro.

We have a separate program/script that takes our Orders database file
(in tab-delimited text format) and converts it into the program we use
for all our inventory/bookkeeping/accounting/order processing, etc. This
script/program identifies the needed information and works with it based
on its position in the fields of the data file. So, any addition or
rearrangement of fields will make it go haywire.

Question: Does anyone here have a list of the specific changes in
fields (additions, deletions, and repositionings) from version 4.0 to
version 6.0. I've noticed at least 2 added ones so far: Coupon, and
Product type. Are there more? Also, can I do anything in the
BackOffice to add or remove these fields (other than opening the
database in Excel once I download and manually deleting)?

BTW, Lexiconn was able to transfer our entire backoffice AND keep our
Order Anywhere links intact. I remain very impressed.

Chris
mlcswoodworking.com