Hemi v2.2.33 released - 22.11.2022
Story
HEMISPHERE-14941 [Very] Make statuses on claims with readable names
Description
Instead of using the codes directly concatenated (example 1516) that define the status we are working with for ease of human interaction we are to use description names
HEMISPHERE-15561 [Amazon SP-API] Order Management
Description
Technical Scope available here - Amazon SP API - Order management {: data-inline-card='' }
HEMISPHERE-15582 [OnBuy] Offer create should not be looking at "listingStatus" = "active"
Description
It seems at a certain point while discussing how onBuy should act we’ve taken the decision for the offer create to be looking at the “listingStatus” but at the same time the product create (rightfully) is not updating this field. The flow in this regard at least seems right in the doc at the moment but just to reiterate with a few words
Content create (or Check for product) sets the product as “created” for the offer create to run. It doesn’t need to check the “listingStatus” to be active as nothing will actually set this that way. Once the offer successfully is created on onBuy then we should set the listingStatus on Active as this is the point in which the product is actually “active” and available for a buyer to purchase
HEMISPHERE-15781 [TradeByte] Different Cancellation Messages based on the Refund Reason
Description
At the moment when we are sending cancel message to TradeByte the type is always “CUST_CANCEL”
However for the marketplace this is the actual reason.
We need to incorporate a logic where we can control this using Order Payment > Refund Reasons field.
By default if there is not refund reason we send “CUST_CANCEL”
If we specify Customer Cancel we push message type “CUST_CANCEL”
If we specify No Inventory we push message type “NO_INVENTORY”
The alternative would be to provide:
Please note we need to also add the reason for the Trade byte channel in the order_refund_reasontable
The new values should be:
”Customer Cancel”
”No Inventory”
Based on this selection we decide what message type to push.
HEMISPHERE-15798 [OnBuy] Orders without items handling
Description
It seems we’ve hit a specific case where we receive orders from OnBuy that are supposed to be “RFS” as per all other parameters BUT we don’t get any Order Items for them which results in a RFS order in Hemi with no Products on it.
As per our latest decisions any order that has some specific misses about it (missing crucial address info, product identifiers, etc.) should be moved to “Incomplete” status. Can we please implement the same logic on OnBuy? Best case scenario will be if on a subsequent order download we receive the same order and identify it as good and RFS that we update it with everything needed in Hemi (including the status) so it can be processed properly forward.
In this specific case our issue is with the fact we can’t identify the items - either they are not received at all OR there is no mapping of SKU from the appointed mapping (direct 121 mapping or via identifier, for example EAN map to find the SKU)
HEMISPHERE-15810 [AmazonSP] Stock and Price flows
Description
The technical documentation is available here - https://wearepentagon.atlassian.net/wiki/spaces/HEMI/pages/2889383959/Amazon+SP+API+-+Stock+Price+Updates {: data-inline-card='' }
HEMISPHERE-15812 [AmazonSP] Integration control flags
Description
As we have added all the feeds to be controlled into one cron because of the shared limit we will need to be able to control what actions to be performed for each account.
Thus we have to include additional flag in Account Amazon table as:
| Label | Type | Default value |
|---|---|---|
| Update Stock | Checkbox | true |
| Update Price | Checkbox | true |
| Ship Orders | Checkbox | true |
| Upload Invoices | Checkbox | true |
| Cancel Orders | Checkbox | true |
| Refund Orders | Checkbox | true |
Each of the flags will indicate which feeds we would like to activate for the specific account and we will be able to take control of the flows.
HEMISPHERE-15814 [Walmart] Include intentToCancelOverride when shipping orders
Description
We need to include in payload additional node intentToCancelOverride and hardcode it as true.
Please find more details here - Walmart Order Shipment {: data-inline-card='' }
HEMISPHERE-15831 [Shopify Connector] Amend the VAT/tax percentage sent
Description
We need to round the second symbol after the commaVAT/tax percentage when creating orders in Shopify. Currently we are rounding at the 4th symbol but picking only the first 2 when sending orders. This needs to happen in both ‘rate’ fields in ‘line items’ and ‘shipping_lines’ nodes.
Please note If Order Item > Tax Percent is missing we need to calculate it internally (Order Item > Item Tax Price / Order Item > Item Price) and push it as the rate
HEMISPHERE-15838 [ShopifyERP] Get Products Cron returns "Undefined index:"
Description
This was fixed for the Get Stock cron (
[HEMISPHERE-15804](https://hemi.atlassian.net/browse/HEMISPHERE-15804)
-
Getting issue details...
STATUS{: data-inline-card='' }) however we did not fix it in Get Products cron.
Thus we want to do the same thing for the /var/www/shopify-connector/bin/cron_shopif_100_get_product_details.php
The issue comes from our database and because our fields are case insensitive.
HEMISPHERE-15840 [ShopifyConnector] Include Company Name in Create Orders
Description
At the moment we are not mapping the company name in the payload thus we need to start sending
Orders > Billing Company Name as "company"
However we will need to add additional option in Account Shopify Connector called “Account Name As Company Name“ which by default will be false (0).
However if this is set as true (1) we will sent the company as Account Name and the mapping will be
Account > Name as "company"
Basically there will be two cases:
Case #1 (Account Name As Company Name = Yes)
We always send the company name in the payload as Account Name
Case #2 (Account Name As Company Name = No)
We only send the company name in the payload if we have populated Orders > Billing Company Name
HEMISPHERE-15843 [AmazonSP] Settlement report file extension
Description
At the moment the settlement reports are downloaded as .csv files however we just want to change the extension to .txt and to be stored on the FTP as txt.
Also the file name is “SettlementReport_1186938019236.txt“ we need to change it to “AmazonSettlementReport_1186938019236.txt“
HEMISPHERE-15858 [Ebay][Amazon] Issue with masked SKUs
Description
As previously reported it seems we have a problem with marketplaces that are masking SKUs. I am not 100% sure this needs to come in Shopify but we might pull out the needed tasks in this story to amend affected marketplace integrations
The main issue is when we are downloading orders in Product on Order > Item SKU we are storing the information masked for specific characters. In the Shopify specific case this then results in us not being able to send the order to Shopify because we map by the SKU to Product and then to Product Shopify from where we pick the specific store ID. As the start of this process (Product on Order) is masked we don’t map anything and we then try to create a Shopify Order with empty product info
This is reported on Start Fitness (as we usually don’t have special symbols in the SKUs but they have for some) so in terms of priority if this needs to be amended in Marketplace integrations we should pick theirs first (or make an addition to the Shopify Connector)
HEMISPHERE-15871 [OpenAPI] Release Open API and include new field
Description
We need to add the API to https://decathlon.wearepentagon.com/alpha/en/login and we want to include in the POST ORDER request Product In Order > Connector ID
So the client can update that field.
Also please prepare the production credentials and endpoint as well.
HEMISPHERE-15905 [John Lewis] Prepare the Stock Error consumption
Description
As we didn’t have any example or real explanation what to expect on Stock CSV exchange and now we have with the live testing we’ve found that we are not processing Error files for stock as expected, which results in records in Hemi being marked as “normal” where they should be marked as Error. The general logic flow seems to be the same as the expectation but the file itself that we receive is different
@60b3f5dd3c2f6d006e6dd6ee - please add the example file as well.
HEMISPHERE-15906 [Puma] Order and Status ID mapping addition
Description
Due to the fact Puma can’t intake an order ID bigger than specific values we need to introduce a workaround in the connector. At the moment we are passing both our ID in the export to them (as a parameter in a field) and the marketplace order ID. After that Puma return back to us only the marketplace order ID which we use to map to the correct order. What we need to do is for those Marketplaces that have IDs that Puma can’t work with send them in both places our Hemi Order ID
We should be able to control this (via a trigger in Account Puma) and it should also reflect the way we read any of the files back (Status update, Shipping update, Cancel update, Returns update). I fully realise this is not ideal but we didn’t manage to convince them to use our ID and keep the MP ID as a value the first time when we built this and it is still the same where they agree to this workaround only if there are issues with the MP ID itself. This will at least allow us to easily control the outcome and mapping once done
Addition: new task is added to revert a change for field “invoice-no” - it always need to be exporting the Marketplace Order ID. Also please revert any changes done to the feed for Returns as it will always map to the Marketplace Order ID as well (the only feed that connects to the Invoice-no in the order export)
HEMISPHERE-15919 [AmazonSP]Include the feed payload in the log
Description
When we set DEVMODETRUE for cron var/www/amazon_v2/bin/cron_amazon_000_feed_create_queue_manager.php we do not store the actual payload of what we have send to Amazon.
We want to start storing this info as well.
At the moment this is fixed on Dari machine.
HEMISPHERE-15951 [AmazonSP]Feed Priority and Limit
Description
We need to set the following priority when reading responses from Amazon:
Order Fulfillment
Order Refund
Order Cancel
Listing Price Update
Listing Stock Update
Invoice
Also could you please set a limit of 32k objects per feed for price and stock feed.
HEMISPHERE-15955 [eBay] Get Orders start storing DeliveryByDate
Description
At the moment eBay is not storing the Orders > Delivery By Date field so we need to start mapping from the payload the
OrderArray.Order.TransactionArray.Transaction.ShippingServiceSelected.ShippingPackageInfo.EstimatedDeliveryTimeMax
Please note we need to the store the date as Unix timestamp in the database
Bug
HEMISPHERE-15489 [LaRedoute] Refund return error but it is actually processed on the MP
Description
Hey,
There seems to be an issue when we receive the refund response from LaRedoute. The error that returns to us from refunding is this one:
'Error Fetching HTTP headers'.
The refund was sent to the MP correctly, on the same date as the error when returning to Hemi.
Example:
https://arcade.myhemisphere.com/alpha/en/record-view/3100/101396281
This happens on all clients that have LaRedoute integration.
HEMISPHERE-15663 [Debenhams] Writing the error for a variation group only on one product from the variation [Whereisthatfrom]
Description
We are writing the error for a variation group only on one of the products in the group (with the smallest ID)
And example is : https://whereisthatfrom.wearepentagon.com/alpha/en/table-view/1001 filter by Variation Group PA : WTR1 and you will see 6 products and only one has an List/Update error, the other 5 appear as successfully listed, but they are not. I am attaching the response from Debenhams where all 6 products from this variation are with the same error.
HEMISPHERE-15739 [Catch] Remove "failed" Status for Marketplace Feed (Arcade)
Description
The same issue was fixed a while ago for another Mirakl marketplace - Secret Sales
HEMISPHERE-15431
Getting issue details...
STATUS{: data-inline-card='' }
We need the same done for Catch as well, since we have a lot of feeds with failed status which leads to us not processing feeds and leaving products with unchanged statuses while they should be listed or with an error.
This seems to be valid for the listing_create feeds.
HEMISPHERE-15799 [Core]Item Account record view does not work(V3apparel)
Description
In the Item account table, when clicking on any product on the icon (view), return error:
https://v3apparel.wearepentagon.com/alpha/en/record-view/1001/139
HEMISPHERE-15811 [Debenhams] Incorrect Cron Group Lines
Description
The Mysql for the cron tab “02_install_crontab.sql“ is incorrect and we have wrong crontab lines.
Also please note the correct php version should be php74
HEMISPHERE-15844 [ProSKU] File mover returns error (citychic)
Description
The grouper returns error
[E] [03.10.2022 09:39:16 | 1664786356] For ProSku FTP [1] to FTP [6]. Could not upload the files.
HEMISPHERE-15848 [Walmart] Setting incorrect update price/quantity error (CityChic)
Description
We are setting ‘[EXTERNAL]Invalid token’ error to the whole batch of products set for updating quantity/price. However, we believe some product/products are leading to this since updating products one by one or in small batches does not result in the same error (feed limit could also be an expaination). Example products with tag ‘WM WEEK 11 - 21.09’. Here are 2 examples
There were ~4000 products with that error. We’ve raised the flags to the ones with tags ‘WM WEEK 12 28.09’ and ‘WM 13.09.2022’ and all of them got cleared (updated to Not Needed status).
2952 products are now left with the error (on update quantity). The error keeps appearing when we attempt to update them all at once. We won’t be updating them by tag so you can test with them
HEMISPHERE-15852 [Shopify-Connector] Remove html tag symbol when exporting orders (startfitness)
Description
We have exported an order with Shipping Address : St John's House and this has caused issues on the client’s systems as it did not recognize the address.
We want to be removing the “/” (or the HTML code for it) and export the address as “St John's House” to Shopify from the following fields :
Orders → Shipping Buyer Name
Orders → Shipping Street 1
Orders → Shipping Street 2
Orders → Billing Name
Orders → Billing Street 1
Orders → Billing Street 2
This was fixed a while ago but something might have reverted it.
[HEMISPHERE-15667](https://hemi.atlassian.net/browse/HEMISPHERE-15667)
-
Getting issue details...
STATUS{: data-inline-card='' }
HEMISPHERE-15860 [Very] Acknowledge and Dispatch status updates validation by Buyer User ID
Description
I am not 100% sure why we have such a validation, I can’t see anything in the docs and can’t remember if it has been discussed BUT as of today Very has stopped providing PII info (including Buyer User ID) which is in effect affecting the following updates.
We need to remove this validation on CityChic until we investigate deeper and see if we want to handle the issue in another way OR remove it in general and prepare for deployment everywhere
HEMISPHERE-15861 [Amazon] Order Fulfillment feed return Error
Description
Restructure of the payload is required.
HEMISPHERE-15880 [Shopify-Connector] Not exporting orders due to error (startfitness)
Description
We seem to be getting the error “Shipping lines is invalid\r\nDebenhams ukstandard Tax lines is invalid” since the release on Whereisthatfrom and we are unable to export orders.
HEMISPHERE-15882 [Core] Item import stuck on 'In Progress' (Arcade2)
Description
Hi team,
The manual item import gets stuck to 'In Progress'. Also trying different extensions like .csv and .xlsx, there are no have any functions or formulas.
HEMISPHERE-15896 [John Lewis] Stock update wrong header (arcade2)
Description
We seem to be submitting wrong header when creating the .csv file with the stock update cron.
We have one of the headers as “standard_lead_time_to_ delivery_in_days" The issue is that there is a interval between "to_" and "delivery_in_days" . We need to remove the interval and send the header as "standard_lead_time_to_delivery_in_days"
HEMISPHERE-15901 [Shopify Connector] Not getting Shopify IDs for some products (WhereIsThatFrom)
Description
There seems to be something wrong with getting the Shopify IDs for some products (examples below, alongside with their whole variations). The products actually exist in Shopify and are in stock.
There are some errors/warnings below, that appear when we run the cron manually. However, I don’t think this is the case because indeed we have product accounts for these SKUs and after all the get shopify IDs should only update info in item_shopify table and should have nothing to do with item_account or it’s slave tables.
HEMISPHERE-15902 [John Lewis] Get Orders returns fatal error if there is no order to be downloaded (arcade2)
Description
The cron seems to be returning fatal error if there is no order file on the FTP. If there is a file, we are processing it correctly and there is no error.
HEMISPHERE-15904 [John Lewis] Ship Orders return fatal error (arcade2)
Description
The Ship orders is returning fatal error :
HEMISPHERE-15921 [Zalando] Variation in Config
Description
The way Zalando handles variations is on 2 levels - In the config section you can pretty much vary by anything - colour, material, fit, etc. - second is the size which goes under each config in the Simples section
It seems at the moment we are not picking the values for the config variables properly for each config section but rather just taking from the first listing (as we usually do for the attributes section)
In this case I would’ve expected the "color_code.primary": "704" to be different but the "supplier_color": "beige" to be the same everywhere as in Hemi this is set in the IS section and not in the VS section: https://arcade2.wearepentagon.com/alpha/en/record-view/1001/597
HEMISPHERE-15939 [TikTok] Listing create cron wrong validator
Description
When trying to create a listing which has 0 stock we are using wrong validator which doesn’t allow the 0 to go through. This results in error : [INTERNAL]There is a problem with node name [available_stock] - Value cant be empty!`
This is also affecting the End Item flag as it will not work as well.
HEMISPHERE-15941 [AmazonSP] Amazon Integration control flag issue
Description
We do not check the Update Price flag and even if it is turned off we still process the price feeds.
HEMISPHERE-15942 [eBay] Get Managed Payments token error (Arcade2)
Description
We are getting the error below when trying to get the MP token (the one saved in Account Marketplace eBay) for account ID 7 (eBay UK Agent) on Arcade 2 instance.
HEMISPHERE-15948 [Zalando] Stock and Price updates not starting
Description
Both crons (101_stock and 104_price) trough the same error when tried to be executed. Test product at the moment is on Product status = Product Created and has everything else for validations (including closed flags on “no”, update flags on “pending”, etc.)
Just as a reminder, when the product is picked from a “Product Created” state and successfully sends information to Zalando it should set the product State to “Product Published”. And the stock should be taking care for the “Listing Status” as well 🙂
HEMISPHERE-15950 [John Lewis] Not storing hardcoded currency with order download (arcade2)
Description
According to the scope we should have “GBP” as hardcoded Orders > Order Currency value, however at the moment we seem to be not doing this.
Upcoming
What can be expected next as major projects and features are:
- B&Q integration
For more details please refer to this link or if you have any questions, please do not hesitate to contact me.
Useful links: