Categories
View Replies (11)

Resolved Google Merchant export products with free shipping

  1. TRmediendesign
    TRmediendesign
  2. RO CSVI
  3. Wednesday, 28 April 2021
  4.  Subscribe via email
Hello,

I will try to explain my problem as good as possible ;-) This is what I am trying to achieve:


  1. Some of my products are assigned to their main category, but also to a hidden Virtuemart category "Free shipping".
  2. The basic shipping method has a fee and in the configuration there is an option to disable it for selected categories. Using this option I have disabled it for the category "Free shipping".
  3. There is a second shipping method without a fee and in the configuration I have enabled it for the category "Free shipping" only.


In the shop this setup is working properly so if a product that is assigned to the category "Free shipping" is added to the basket, the shipping fee is removed automatically. The shopper gets a free shipping. But in the CSVI export all <g:shipping> fields are empty, except for one product (the first in the list with the ID "1";).

If I unselect the option mentioned in step 2 and enable this shipping method for all products, the export works, but also the products that are supposed to have no shipping cost are calculated with the basic fee.

Is there a problem in the export script or is this simply not possible?
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Tobias,
We found that the cause for empty shipping prices in export. That is because VirtueMart removes the shipping method when a product is assigned to any blocked category. This is not a problem with VirtueMart because it reloads page on checkout so the removed shipping method is reset back. With RO CSVI we do not reload VirtueMart page and so the shipping method which has been removed by VirtueMart stays removed for consecutive products in export. This is causing custom_shipping field to be empty. The fix for now is a hack with VirtueMart code. We are trying to get this code added in VirtueMart else the fix will be added with RO CSVI as a maintenance task. For you to have the fix.

1. Please load the attached patch file from RO CSVI Maintenance menu.
2. Open file administrator/components/com_virtuemart/plugins/vmpsplugin.php, after line 1673 add the following code(See attached screenshot). Save the file and run the export.




public function reloadPlugins($vendorId)

	{

		$this->methods = null;

		$this->getPluginMethods($vendorId);

	}


Let me know if export works as expected.
Attachments (2)
Screenshot 2021-05-03 at 2.45.42 PM.png Screenshot 2021-05-03 at 2.45.42 PM.png
patch_vm_2021_05_03.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
RO CSVI does not calculate any of prices, VirtueMart does. In the sense RO CSVI uses VirtueMart code for calculating the prices. if <g:shipping> is empty then it means RO CSVI is not getting any price from VirtueMart.

In export template on Options tab select a specific category in Category field filter and check the export. See if the product gets shipping costs then. You can also select Free shipping category and see how the shipping cost shows for these products.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
TRmediendesign
TRmediendesign
Accepted Answer Pending Moderation
Hello,

I understand what you are saying but it seems that there is a bug in the RO CSVI functionality.

Product #1 is correct and the shipping price is shown in the export.

Product #2 is a product with free shipping and the g:shipping node is not shown in the export because the value is empty. This is also correct and no problem for me.

Product #3 is a product WITH shipping cost but it is not shown in the export.

All products in the list after product #2 are broken and without shipping cost information. If I disable the free shipping products, the complete export is correct and all shipping prices are shown. Those products definitely break the RO CSVI export script somehow and in all following products the g:shipping node is empty.

Furthermore the parameter "Include/Exclude categories" does not work properly. If I set it to "exclude" a category, the export contains this category only. It does an "include" instead of an "exclude".
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Ok, i need the same type of data as yours to test the export and see if i can reproduce the issue. I tried to create a scenario like you have explained in your initial post for products and shipment method in my local test site but couldn't get that to work. Please send me sample of screenshots on how you have set up the shipping and screenshots for products with categories. I will set it up in my local site and check the export issue. If that does not help, i need to check the export on your site.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
TRmediendesign
TRmediendesign
Accepted Answer Pending Moderation
Hello,

the setup is pretty simple:

Categories:

#1 With shipping fee
#2 No shipping fee

Shipment methods:

#1 With shipping fee (Blocking categories: #2 "No shipping fee";)
#2 No shipping fee (Categories: #2 "No shipping fee";)

Products:

#1 Product A (assigned to category #1)
#2 Product B (assigned to category #1 and #2)
#3 Product C (assigned to category #1)
#4 Product D (assigned to category #1)

The order of the products is important so you can see that product #1 is exported correctly and that product #2 and the following #3 and #4 are not.

I hope this helps.

Kind regards
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for the details. I setup products and categories as explained. See attached screenshots. I am still not able to reproduce the error of shipping details not shown in export file. Screenshot of export file is also attached. Let me know if i am missing something with my setup.

You can send me your site login details to check the export. You can post the access details in Site details tab under your reply.
Attachments (5)
Screenshot 2021-04-29 at 3.32.32 PM.png Screenshot 2021-04-29 at 3.32.32 PM.png
Screenshot 2021-04-29 at 3.32.44 PM.png Screenshot 2021-04-29 at 3.32.44 PM.png
Screenshot 2021-04-29 at 3.33.22 PM.png Screenshot 2021-04-29 at 3.33.22 PM.png
Screenshot 2021-04-29 at 3.34.45 PM.png Screenshot 2021-04-29 at 3.34.45 PM.png
Screenshot 2021-04-29 at 3.36.18 PM.png Screenshot 2021-04-29 at 3.36.18 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
TRmediendesign
TRmediendesign
Accepted Answer Pending Moderation
Hello,

your setup seems like mine but for me it is not working. I setup a development area for you and attached the credentials. It is a simple quick and dirty installation without SSL just for testing purposes. The products with the IDs #2 and #157 cause the problems. If you disable them the entire export is correct.

Kind regards,
Tobias
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Tobias,
Thank you for the details but for some reason if i enter the credentials and click Anmelden button to login, index.php file gets downloaded instead of getting into site. Can you check it? Also please post (S)FTP details of the site.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
TRmediendesign
TRmediendesign
Accepted Answer Pending Moderation
Hi,

I can login without any problems. It seems that the problem is related to your computer but I have no clue what's going wrong there. Maybe you can try using the incognito mode of the browser or another browser.

Nevertheless I have attached the SFTP data for you, too.
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for the FTP details. I am able to see the issue with your data and Google export template. I am looking into the issue and will get back on my findings.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
TRmediendesign
TRmediendesign
Accepted Answer Pending Moderation
Hello Tharuna,

this works perfectly in my export. Thanks a lot!

Kind regards,
Tobias
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!