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.
|
|
|
|
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. |
|
|
|
|
Rank: Member
Groups: Authorized User, Developers, Registered Joined: 12/19/2018(UTC) Posts: 11
|
|
|
|
|
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? |
|
|
|
|
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
|
|
|
|
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. |
|
|
|
|
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%20StandardWhat 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.
|
|
|
|
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.
|
|
|
|
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. |
|
|
|
|
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.
|
|
|
|
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. |
|
|
|
|
Rank: Member
Groups: Authorized User, Developers, Registered Joined: 12/19/2018(UTC) Posts: 11
|
|
|
|
|
Rank: Member
Groups: Authorized User, Developers, Registered Joined: 12/19/2018(UTC) Posts: 11
|
That worked Mike. Thanks.
|
|
|
|
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. |
|
|
|
|
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.
Important Information:
The AbleCommerce Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close