Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tablerates CSV not uploaded/picked up #51

Open
Asitis opened this issue Jan 7, 2020 · 1 comment
Open

Tablerates CSV not uploaded/picked up #51

Asitis opened this issue Jan 7, 2020 · 1 comment

Comments

@Asitis
Copy link

Asitis commented Jan 7, 2020

This issue is similar to this one, but it doesn't conflict with the default Table Rates, but it doesn't allow to configure the DPD table rates.

Steps to reproduce:

  • Have Magento default Table Rates enabled and set up
  • Go to the admin of Magento 2.3.3
  • Go to the Shipping Methods
  • For DPD Pickup, make sure you use the Rate Type "Table Rates" and upload a CSV file
    Also enable default Magento's Table Rates and upload a CSV file there as well (I tested this with Price vs Destination, to be free for orders above 50,- and 10,- for orders below that)
  • Go to the frontend and add any product < 50 to the cart
  • Go to the checkout and check the available shipping methods

Expected result: The DPD Pickup option cost would be 10,-
Actual result: The DPD Pickup option is shown, along with the default Magento table rates, but it is free.

When I go back to check the CSV in the backend, it doesn't update. I export the empty CSV, add my rules to it, save it, upload it. When I download it again I just get a empty CSV again.
There are no errors (file permissions or the like) from Magento or the server.

This is the CSV content I try to use;
Country,Region/State,"Zip/Postal Code","Order Subtotal (and above)","Shipping Price"
*,*,*,0,10
*,*,*,50,0

@Asitis
Copy link
Author

Asitis commented Jan 21, 2020

Found the issue, fixed it ourselves;
Has to do with the dpd_shipping_tablerate table properties. condition_name is set to varchar(20) but it is supposed to be package_value_with_discount (which has 27 characters), so we set the table to varchar(30) and now it does save.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant