How can I change the default value of "Shippable" to Yes?

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

How can I change the default value of "Shippable" to Yes?

Post by Mike718NY » Tue Jul 29, 2008 11:27 am

How can I change the default value of "Shippable" in the
TAXES & SHIPPING section of admin,
to Yes and instead of No?

I would think Yes would be prefered.

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: How can I change the default value of "Shippable" to Yes?

Post by Robbie@FireFold » Tue Jul 29, 2008 11:36 am

Another question I have pondered. I imported without this field and had to go thru the database to change them.

When one of our employee's create an item this would just be 2 more steps that would have to be taken. If defaulted it could save time/mistakes.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

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

Re: How can I change the default value of "Shippable" to Yes?

Post by Mike718NY » Tue Jul 29, 2008 11:44 am

I missed this field in the import also, I just ran:

update ac_products
set ShippableId = 1

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: How can I change the default value of "Shippable" to Yes?

Post by mazhar » Tue Jul 29, 2008 11:53 am

I think on Admin its already fine. When adding a new product it is already Yes and this what you are asking for because on the edit product screen this option is loaded from database. So if in the database you have the products with Shippable option set as No then you must change those.

For example you can use some code like this somewhere on the Merchant side which loads all the products and then set all these to Shipable= Yes

Code: Select all

ProductCollection products = ProductDataSource.LoadForStore();
foreach (Product product in products)
{
       product.ShippableId = 1;
       product.Save();
}

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

Re: How can I change the default value of "Shippable" to Yes?

Post by Mike718NY » Tue Jul 29, 2008 12:00 pm

Yes, the default is Yes . . should have tried to add a new product first :oops:
The default for the Import is No.

Also, the Import default for the WarehouseId is 0.

I ran this just incase that may be a problem:

update ac_products
set WarehouseId = 1

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: How can I change the default value of "Shippable" to Yes?

Post by Robbie@FireFold » Tue Jul 29, 2008 12:10 pm

Mike718NY wrote:Yes, the default is Yes . . should have tried to add a new product first :oops:
The default for the Import is No.

Also, the Import default for the WarehouseId is 0.

I ran this just incase that may be a problem:

update ac_products
set WarehouseId = 1
We are on the same boat haha.

I've only imported - never added a product.

Thanks for the quick answers again.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

Post Reply