logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
Macoy  
#1 Posted : Tuesday, July 16, 2019 11:58:16 AM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

I am sure this is operator error, but we are not able to connect a shipping warehouse and a shipping method. I can put an item (sku 026) in a warehouse but there is no column for a warehouse in shipping methods. We just went live to Able 9.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

MikeR  
#2 Posted : Tuesday, July 16, 2019 5:17:10 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
You have to create shipping methods and associate them with a warehouse.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Macoy  
#3 Posted : Wednesday, July 17, 2019 2:13:32 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

Mike
I don't see where I can connect my warehouse and shipping method.
See this link for what I am talking about.
https://www.macoy.com/Admin/Shipping/Warehouses

then for shipping methods here is the edit page.
https://www.macoy.com/Admin/Shipping/Methods

Where do I connect the two?
Thanks
MikeR  
#4 Posted : Wednesday, July 17, 2019 9:28:36 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hello,

We have ship groups now for unique shipping situations, what are you trying to accomplish?
Thank you for your support!
Mike Randolph
AbleCommerce.com
Macoy  
#5 Posted : Monday, July 22, 2019 9:57:02 AM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

Mike
We want to set up a Free Shipping for specific products. An example would be this product. Texas Cipher King Solomon's Lone Star
http://www.macoy.com/TEX...King-Solomons-Lone-Star.

If you can show me how to set this one up, I bet I can figure out the rest.
Thanks
MikeR  
#6 Posted : Monday, July 22, 2019 10:12:21 AM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hi,

Just create a ship group called 'Free Group' for example.

Create a shipping method called 'Free Shipping' and set the price to zero and assign it to the 'Free Group'

Edit the product shipping information and assign it to the Free Group.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Macoy  
#7 Posted : Monday, July 22, 2019 1:05:20 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

Mike
That works but I have to assign the other 4,000 products to a ship group. When I try to do it in the "products Assigned to "Ship Standards" (The name of my ship group). It won't let me.

https://www.macoy.com/Ad...oupName=Ships%20Standard

What do you recommend? 99% of all products are set on "All" under Ship Groups. I can change each item one at a time, but not using the above mentioned method.
Macoy  
#8 Posted : Monday, July 22, 2019 1:30:11 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

Also, I don't see where I can export data and then change it there and import it back in again.
MikeR  
#9 Posted : Monday, July 22, 2019 1:50:55 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hello,

You shouldn't need to assign the other products to the ship group. Just make sure you mark the free shipping product as ships separately. I missed that in my earlier explanation. I have put in a feature request for the Data Transfer > Import and Export as Ship Groups was left out.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Macoy  
#10 Posted : Monday, July 22, 2019 2:28:18 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

The problem is the other products have ALL Ship Groups as their ship Group so the free shipping shows up as an option for all products with other shipping options. How do I change the other products from ALL to Selected Ship Groups without doing it individually.
MikeR  
#11 Posted : Monday, July 22, 2019 2:50:50 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hello,

BACKUP YOUR DATABASE BEFORE USING THIS QUERY!

The query will fail if you have already assigned a product to the 'Ships Standard' ID #1 as that would result in a duplicate entry.

But this will put all the products into the 'Ship Standard' ship group, then you'd just go to the free shipping product and change it.

INSERT INTO ac_ProductShipGroups
(ProductId, ShipGroupId)
SELECT ProductId, 1 AS testexp
FROM ac_Products

I didn't realize that there was a table for product to ship groups assignment, so it's not a missing field on the product import/export.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Macoy  
#12 Posted : Monday, July 22, 2019 2:58:22 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

Thanks
Macoy  
#13 Posted : Tuesday, July 23, 2019 1:09:26 PM(UTC)
Macoy

Rank: Member

Groups: Authorized User, Developers, Registered
Joined: 12/19/2018(UTC)
Posts: 11

That worked Mike. Thanks.
MikeR  
#14 Posted : Tuesday, July 23, 2019 1:16:34 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Great!

Thanks for the feedback. We are still learning to support the new version.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.