What is the Exported bit field in the Orders table?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

What is the Exported bit field in the Orders table?

Post by Mike718NY » Mon Nov 09, 2009 11:53 am

Is the Exported bit field in the Orders table used for anything?
I could really use that field for something else.
Could I safely use it for another purpose?

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: What is the Exported bit field in the Orders table?

Post by Mike718NY » Tue Nov 10, 2009 7:48 am

I can't find any documentation on this. Anyone know what it is?

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: What is the Exported bit field in the Orders table?

Post by nickc » Tue Nov 10, 2009 10:46 am

I've been using to flag orders after they are pushed to my fulfiller. Don't know if Able has ever implemented the field; I'm using an older build. In my world, my app is the only thing that touches it.

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: What is the Exported bit field in the Orders table?

Post by Mike718NY » Tue Nov 10, 2009 10:53 am

Thanks Nick.
Do you think this is related to the Data Port? Where else would an order be "exported" to?

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: What is the Exported bit field in the Orders table?

Post by nickc » Tue Nov 10, 2009 11:28 am

That would be one possibility. I think how I'm using is more likely - the field implies a reason to persist the status; i.e. once an order is exported, you don't want to be able to export it a second time. Dataport is a more generic tool - you might be exporting for reporting purposes, in which case you would want to be able to export an order over and over.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: What is the Exported bit field in the Orders table?

Post by AbleMods » Thu Nov 19, 2009 7:24 am

Able does not use this field.

I use it in my Quickbooks module to mark which orders have been pushed to Quickbooks.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: What is the Exported bit field in the Orders table?

Post by Mike718NY » Thu Nov 19, 2009 11:59 am

I wish there were a few more of these "un-used" fields.
It would make customizations a lot easier.
Should add a few more in Products, Orders, and OrderItems.
I guess they are not needed in Products because of custom fields,
but definately in Orders and OrderItems.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: What is the Exported bit field in the Orders table?

Post by AbleMods » Thu Nov 19, 2009 1:00 pm

LineMessage in orderitems is unused.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: What is the Exported bit field in the Orders table?

Post by Mike718NY » Thu Nov 19, 2009 1:18 pm

thanks . . I'll take it!

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: What is the Exported bit field in the Orders table?

Post by AbleMods » Thu Nov 19, 2009 1:20 pm

AbleMods wrote:LineMessage in orderitems is unused.
The nice thing about it is it's also in the basket class. That means you can use it pre-checkout to store something and it'll pass unmodified all the way through to the order post-checkout.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply