[BUG] Something (?) went wrong while importing GLS rates
Closed this issue · 9 comments
To Reproduce
Steps to reproduce the behavior:
- Go to Configuration -> Sales -> Shipping Methods
- Switch to 'website configuration scope'
- Click on Export CSV
- Upload that same CSV on the 'import rates'
- Click save
- "Something" went wrong
Expected result
A clean import of GLS rates. Other then that, a more clear error message. At first I was thinking I broke the CSV, but since it also breaks on the data it exports itself I guess something else is up.
Actual result
Shows error Something went wrong while importing GLS rates.. No database changes are made as far as I can see.
Workaround
Manually hack this into the database, with the risk of many unintended side-effects
Screenshots
Nope
** Please complete the following information**
- Magento version: "magento/product-community-edition": "2.3.4",
- PHP version: 7.3.23
- TIG GLS version: 1.3.2
Hi @vandijkstef ,
Could you contact us at support@tig.nl with your rates so we can investigate this further?
Have a great day,
Jeffrey
I have the same issue with a very simple import csv file. Should I contact support through email as well?
[EDIT]
This is in the exception log:
[2021-03-31 20:15:57] main.CRITICAL: Requested column "Weight (and above)" cannot be resolved {"exception":"[object] (Magento\\OfflineShipping\\Model\\ResourceModel\\Carrier\\Tablerate\\CSV\\ColumnNotFoundException(code: 0): Requested column \"Weight (and above)\" cannot be resolved at /home/user/domains/domein.nl/public_html/vendor/tig/gls-magento2/Model/ResourceModel/Carrier/GLS/CSV/ColumnResolver.php:92)"} []
When changing the column Order Subtotal (and above) to Weight (and above) the import is succesful. So it seems the default csv which you can download has the wrong header which is a bit confusing.
Hi @jghaanstra
You can contact us for sure, so we can help you further. It sounds like the is an incorrect shipping setting. Contact us at support@tig.nl, and we will be able to assist you further.
Have a great day,
Jeffrey
Did you receive my email/CSV? Haven't heard back from you guys yet.
Thanks!
Hi @vandijkstef ,
We don't see any open issues. Did you receive an issue number for our system?
If you have an issue number please tell me this one so I can check the status.
Have a great day,
Jeffrey
No I did not receive an issue number from your system. I've send the email within minutes after you requested to. Also I've never received a 'bounce' or 'undelivered'.
I just send it again, this time without attachment but the raw CSV data pasted under the email. But you can also use the 'default' CSV you can download from the Magento Admin since its based on that.
Hi @vandijkstef,
Looks like we are not receiving your emails, could you give us your mail so I can contact you?
Have a great day,
Jeffrey
@tig-jeffreybranderhorst Uh oh! That is very interesting... You can reach me on stef@vandijkstef.nl