Shipping Warehouse - Can't connect a shipping method to a warehouse like before Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

Macoy		#1 Posted : Tuesday, July 16, 2019 11:58:16 AM(UTC)
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.
User Profile View All Posts by User View Thanks

	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)
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
User Profile View All Posts by User View Thanks

Macoy		#3 Posted : Wednesday, July 17, 2019 2:13:32 PM(UTC)
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
User Profile View All Posts by User View Thanks

MikeR		#4 Posted : Wednesday, July 17, 2019 9:28:36 PM(UTC)
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
User Profile View All Posts by User View Thanks

Macoy		#5 Posted : Monday, July 22, 2019 9:57:02 AM(UTC)
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
User Profile View All Posts by User View Thanks

MikeR		#6 Posted : Monday, July 22, 2019 10:12:21 AM(UTC)
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
User Profile View All Posts by User View Thanks

Macoy		#7 Posted : Monday, July 22, 2019 1:05:20 PM(UTC)
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.
User Profile View All Posts by User View Thanks

Macoy		#8 Posted : Monday, July 22, 2019 1:30:11 PM(UTC)
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.
User Profile View All Posts by User View Thanks

MikeR		#9 Posted : Monday, July 22, 2019 1:50:55 PM(UTC)
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
User Profile View All Posts by User View Thanks

Macoy		#10 Posted : Monday, July 22, 2019 2:28:18 PM(UTC)
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.
User Profile View All Posts by User View Thanks

MikeR		#11 Posted : Monday, July 22, 2019 2:50:50 PM(UTC)
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
User Profile View All Posts by User View Thanks

Macoy		#12 Posted : Monday, July 22, 2019 2:58:22 PM(UTC)
Rank: Member Groups: Authorized User, Developers, Registered Joined: 12/19/2018(UTC) Posts: 11		Thanks
User Profile View All Posts by User View Thanks

Macoy		#13 Posted : Tuesday, July 23, 2019 1:09:26 PM(UTC)
Rank: Member Groups: Authorized User, Developers, Registered Joined: 12/19/2018(UTC) Posts: 11		That worked Mike. Thanks.
User Profile View All Posts by User View Thanks

MikeR		#14 Posted : Tuesday, July 23, 2019 1:16:34 PM(UTC)
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
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (6)