Hemi v2.2.31 released - 28.09.2022
Release notes - Hemi Connect - Hemi Version 2.2.31
Story
HEMISPHERE-14974 [Shopify] Tracking URL to be get from Courriers
Description
We would like to make additional logic for the tracking urls for Shopify and be able to get them from the Couriers table (1513)
If the order carrier matches any Couriers in 1513 table we get the tracking URL from Couriers else we do not push the tracking URL.
HEMISPHERE-15136 [Import] Start using the FTP port from the Automatic Import field
Description
At the moment the FTP ports for the Imports are pre-defined depends on the type we select.
We need to change this and start using the port field.
HEMISPHERE-15204 [Zalando] Authenticate
Description
HEMISPHERE-15206 [Zalando] Product Price Create and Update
Description
HEMISPHERE-15207 [Zalando] Stock Update
Description
HEMISPHERE-15217 [Zalando] Orders download
Description
HEMISPHERE-15218 [Zalando] Orders acknowledgement
Description
Zalando Order Export (acknowledge)
HEMISPHERE-15219 [Zalando] Orders shipment (2 step operation)
Description
Zalando Order Tracking and Shipping
HEMISPHERE-15290 [Walmart Orders Abstraction] Ship orders using the latest Shipment options and abstraction
Description
We need to transfer the Shipment of Walmart orders to the newest version of the abstraction layer. We should also move in the process the logic of the shipment using the new logic that utilises the Shipment table and the allowance of multiple and split shipments
Please use this version of the doc Walmart Order Shipment and be on the lookout for a detailed explanation of the new Shipment model to help with the logic (to be added by 30th Nov EOB)
HEMISPHERE-15292 [Zalando] Download taxonomy
Description
HEMISPHERE-15385 [Puma] Read Returns and store Refund in Hemi
Description
We have to start reading a return coming from their warehouse and based on it store a refund in Hemi so we can process it to the Marketplace. Details with needed steps, mapping and validations can be found here: Puma Read Returns
HEMISPHERE-15427 [Amazon SP] Authorization Flow
Description
HEMISPHERE-15438 [Interaction] In-line edit breaking
Description
We have to rework the in-line edit functionality as it is currently breaking up on multiple different occasions.
- Inputting "0" sometimes inserts blank values in Hemisphere due to nature of fields
- Trying to save breaks it up popping a browser notification for wrong input but saving 5 times in a row at the end allows it to go through
- Sometimes the edit opens on a completely different plane than the visual on the screen
Additionally to the flagged issues we need to consider adding keyboard interaction when using such records:
- Space/Enter triggers Boolean operations
- Arrows trigger opening selection in a enumeration drop down and Enter chooses the selection
- Ctrl(Cmnd) + Enter saves the record
HEMISPHERE-15451 [Shopify ERP Connector] Authorization and Database structure
Description
https://wearepentagon.atlassian.net/wiki/spaces/HEMI/pages/2840428549/Shopify+as+ERP+Technical+Scope
HEMISPHERE-15452 [Shopify ERP Connector] Product Management
Description
Shopify as ERP Product Management Technical Scope
HEMISPHERE-15453 [Shopify ERP Connector] Order Management
Description
HEMISPHERE-15466 [Shipping] Amend Custom Shipment creation script to follow the new Shipment Abstraction guidelines
Description
HEMISPHERE-15493 [API] Add MPN to the GET Products call response
Description
We added the MPN to be returned with the GET Products call
HEMISPHERE-15498 [Shopify ERP Connector] Add "note_attributes" and "properties" when creating order
Description
We need to include two additional fields when creating orders to Shopify.
Orders> Marketplace Fulfillment Channel
Orders Amazon > Latest Ship Date
Orders > Buyer User ID
Orders > Selling Manager SalesRecordNumber
Orders > Account (we need to export the name not the ID) We include only the fields which are not empty so if we have Amazon orders we will have Fulfillment Channel and Latest Ship Date but if we have eBay we will have Sales Rec Num and Buyer User ID
HEMISPHERE-15507 [Very] Marketplace Order ID amendments
Description
It was just found that Very are working with recycled order numbers and multiple order numbers
This means that we get duplicate marketplace order ids from Very. This is causing multiple issues starting with not downloading new orders that have a duplicated ID
HEMISPHERE-15508 [Very] Get claims to only process file if it matches order in Hemi
Description
We noticed that sometimes when there is a claim sometimes we process it before downloading the order. We need to amend the get claims cron to :
1) Validate if all orders in the claim are existing on Hemi, if so, then process the file as normal
2) If there are multiple orders in the claim file, and any is not in Hemi, we process all the orders that are matched in Hemi and leave the file and wait 1 day for the order. Each run we validate if the claim exists, and if it does, we skip it.
3) If the order shows up within 24h - move the file to Processed, if the order doesn't show up - move the file to Error.
HEMISPHERE-15519 [Shopify as ERP] Get Full Product Details File
Description
HEMISPHERE-15525 [Debenhams] Shipping orders error handle
Description
We need to change the logic to the way we are shipping order on Debenhams so
if we have Orders > Update Shipping Pending = Yes we first update the shipping details (Courier, Tracking, Tracking URL) using OR23 then we just mark the order as shipped in Mirakl with OR24 but before all this happen we need to validate the shipping details.
In order to do so we check if the Orders > Courier is part from the Mirakl shipping list (SH21).
If we do not match any courier we are shipping with “other“ carrier we have to push empty carrier code with only carrier name (Orders > Carrier) and tracking num (Orders > Tracking Number)
Because Mirakl do no support partial shipping we still need to add the shipments in the order but will always ship the full order.
HEMISPHERE-15527 (Fruugo) Get orders cron to look for 7 days back
Description
It seems like Fruugo sometimes are sending us orders with old date, for example today we have received an order in Fruugo with date 09/05 and we have not downloaded it in Hemi.
At the moment I believe the cron is looking for 2 days back, however we need to amend it and make it look 7 days back.
HEMISPHERE-15562 [Magento2] Ignore statuses when downloading refunds
Description
At the moment to add a refund we are looking for statuses: partial_returned, canceled, closed and processing.
We need to ignore the Magento2 status and always store the refund in Hemi unless we already have added it for the actual order item.
We have to use our standard refund processor logic
All validations should remains as it as in terms of refunded so far sum and refunded amount to make sure we wont add the same refund for the same item twice or refund more than we can.
The idea is despite what order status we receive from Magento if there is a refund we need to store it.
Once the refund is completed we will update all the relevant fields and sums
HEMISPHERE-15568 [Core] Update form_slave to re-order tables views
Description
Database update
HEMISPHERE-15570 [ShopifyEPR] Create Orders response changes(StartFitnes)
Description
When we try to export the orders to Shopify we receive error. Because we are expecting only arrays however we shall expect string as well.
HEMISPHERE-15577 [Core] Include Search Terms in the Item Import
Description
We need to be able to import into the new field Item Account Real > Search Terms using our import functionality.
The import type need to be “Item“ and the field should have the same logic as Item > More Picture URL.
Basically we will have separate column in the file for each search term and will be mapped in the import layout to the same field.
HEMISPHERE-15587 [Core] Labels Update Item and Order Item
Description
We need to update the following fields labels as follows
Item > Weight → Weight(g)
Item > Width → Width(cm)
Item > Height → Height(cm)
Item > Length → Length(cm)
Order Item > Weight → Weight(g)
Order Item > Width → Width(cm)
Order Item > Height → Height(cm)
Order Item > Length→ Length(cm)
HEMISPHERE-15592 [ShopifyERP] Get Shipments Amendments
Description
We need to increase the overlap period from the date store in last date run table to 90 minutes.
Also we need to include additional parameter “status:any“ to make sure all orders will be returned in the response.
HEMISPHERE-15593 [ShopifyConnector] Send "transactions" when create order
Description
At the moment we are not specifying the transaction details and this results in “Paid By Customer 0.00” on the Shopify
If the payment row with type=payment is with status=completed we treat this as - financial_status = paid
If the payment row is missing or is with status= pending we treat this as - financial_status = unpaid
HEMISPHERE-15596 [eBay] include a boolean field in Item Account eBay to control sending
Description
If we have mixed hosted images on eBay when we try to update the product we receive error
We need a new field included in Item Account eBay (named ‘Skip updating images’). It should control whether we will be sending the whole
This need to be applied only when we are updating products
The REVISE_FIXED_PRICE_ITEM LMS should follow the same logic and use the field as well.
HEMISPHERE-15603 [Fruugo]Sending quantity updates for products with no ChannelItemID [Arcade]
Description
Currently we are sending quantity updates even for products that do not have Item Account > ChannelItemID . This results in error for all products that are in the same feed with the empty Item Account > ChannelItemID product.
We need to include in the sql query to filter and check if the Item Account > ChannelItemID is not empty for the stock updates cron.
HEMISPHERE-15606 [SecretSales] Filter Orders and Products by SHOP_ID
Description
We need to include additional logic in our MIRAKL integration and be able to filter them using MIRAKL shop_id.
The new option will be added in Account SecretSales > Shop ID and by default it will be empty.
If we specify Account SecretSales > Shop ID we will need to include additional parament in the actual requests like:
HEMISPHERE-15608 [ShopifyConnector] Change the way we send the tax rate when creating orders
Description
At the moment we are pushing the tax rates as “20.00” however this results in Shopify as “2000%” so we will need to divide our percentage amount by 100 and push it like “0.20“
HEMISPHERE-15609 [ShopifyConnector] Change shipping service value when creating orders
Description
We need to do a little amendment in the shipping services we send to Shopify (shipping_lines → code and shipping_lines → title). In case of Amazon order, we need to include ‘Amazon’ before the service itself (example, ‘Standard - Std DE Dom_2’ should become ‘Amazon Standard - Std DE Dom_2’). The same logic should be used for eBay as well ('UK_OtherCourier24' becomes ‘eBay UK_OtherCourier24’).
We need to concatenate Account > Marketplace label plus the actual service Orders > Shipping Service based on the Order > Account.
We need to map the Order > Account against Account > ID and get the actual Account > Marketplace.
HEMISPHERE-15611 [eBay] Start Storing US tax amounts
Description
At the moment for eBay we are not storing any US taxes so we will need to start populating them in Hemi.
If we have eBay US order we will receive couple of additional fields in the payload:
Orders > Total Tax Amount will be the SUM amount of all TaxDetails> TaxOnSubtotalAmount
Orders > Shipping Sales Tax will be the SUM amount of all TaxDetails> TaxOnShippingAmount
HEMISPHERE-15612 [ShopifyConnector] Additional Logic for US taxes
Description
We will need to have the option to decide if we would like to use the VAT fields or the Tax fields from our orders when creating new orders in Shopify.
HEMISPHERE-15613 [ShopifyConnector] Pull 'taxable' in Get Product Details
Description
When we are getting the product ids and prices from Shopify we will also need to get the the taxable field.
When we have Shopify Connector > Get Prices = Yes we will obtaining all the Shopify Ids in Item Shopify and also the prices either in Product Account > Price and Product Account > RRP or Product Account > Original Price and Product Account > Original RRP.
HEMISPHERE-15616 [Shopify Connector] Setup callbacks-new machine
Description
Setup the callbacks-new machine to work with the new OAuth authentication.
HEMISPHERE-15617 [Autofixa] Item Account Storesome MPN logic addition
Description
We have a slightly odd case for Autofixa and their clients. A lot of the new clients brought to Hemi via Autofixa are using MPNs with some suffixes or prefixes in their systems. Because communication on order exports and re stock in some cases are based on these MPNs and because Autofixa as a platform needs the real MPN so they can map the product details from an external DB (AutoDoc) when we are creating/updating the offers in their system and / or updating stock & price.
There is an option for some clients we can do workarounds with the values but as I am expecting we might get other strange requests in that regard (and the MPN is acting as the unique identifier in the communication with Autofixa) I want to request that we create a new field in item_account_storesome which is “Marketplace MPN”. The logic should then go like this:
- Offer Create / Update - if there is info filled in Item Account Storesome > Marketplace MPN we take this, if not we follow the same structure as now Item > MPN
- Stock & Price separate scripts - we either do the same as for the Offers OR if we are not selecting this table at the moment to reduce the load I propose we just pick this value from the ChannelItemID field in Item Account and ensure that when an Offer Create runs successfully it will store the correct MPN that it has used in this value
Basically we need to have the option to keep a Marketplace specific MPN that is different than Item > MPN so any other suggestion is also welcome
HEMISPHERE-15621 [ShopifyConnector] Multiply item VAT
Description
Seems like we need to multiply the ‘Item Tax Price’ or ‘Vat Item Price’ (if the tax fields are empty) with the quantity of the product for every order item line before sending it to Shopify. As you can see in the order below, it appears that we owe 1.11 to the customer while the total amount equals the ‘Paid by Customer’. I believe this is the result of the tax being sent as 3.24 total tax, 1.02 shipping tax and 1.11 item tax. However, we have 2 quantity for this product in the order so the item tax should be 2.22 and the calculations are right.
HEMISPHERE-15622 [Core] Add Fruugo Model in the Imports
Description
We need to be able to import info in item account Fruugo using our Item Import Type
ISPHERE-15629 [SecretSales]SS integration rework due to SHOP_ID
Description
We need to rework our current SS integration so we can work with the MIRAKL SHOP_IDs.
HEMISPHERE-15631 [ShopifyConnector] Latest ship date sent in UNIX
Description
We need to amend the “Latest ship date” we are sending Shopify for amazon orders (orders_amazon.latest_ship_date) to show readable dates. Currently it is shown in unix time
HEMISPHERE-15633 [Custom]SD images URL redirection
Description
We need to redirect SD images hosted on their server to goes through our because they have some sort of protection which does not allow to be uploaded on some of the marketplaces.
HEMISPHERE-15637 [ShopifyConnector] Remove "phone" field from the order node
Description
We need to remove the “phone” field within the “order” node when creating orders in Shopify. We should still send the phone in ‘shipping_address’ and ‘billing_address’. This is needed so we skip the phone validation within the order node.
HEMISPHERE-15639 [ShopifyERP]Inventory Behavior passed not as parameter
Description
Even thought in the Shopify documentation it is specified;
”There are additional optional parameters that can be specified in the body of the request when creating an order:
- inventory_behaviour: The behaviour to use when updating inventory. (default:
bypass)- bypass: Do not claim inventory.
- decrement_ignoring_policy: Ignore the product's inventory policy and claim inventory.
- decrement_obeying_policy: Follow the product's inventory policy and claim inventory, if possible.”
HEMISPHERE-15642 [ShopifyConnector] Change the transaction "gateway"
Description
We need to be sending “Ebay” or “Amazon” in the transactions → gateway field (currently hardcoded as ‘manual’).
HEMISPHERE-15646 [ShopifyConnector] Exclude discounts when creating orders in Shopify
Description
We need to stop sending the discounts to Shopify when creating orders.
Currently, we are sending the item price with the discount already included (deducted price).
The mapping changes are as follows:
We need to exclude the discount_codes node from the payload.
HEMISPHERE-15656 [ShopifyERP] Add name in Shipping and Billing address
Description
We need to include the “name“ as well in the shipping and billing address and have a specific order of the fields when we are creating order in Shopify.
Here is the correct mapping and order:
HEMISPHERE-15658 [ShopifyERP] Create Orders Currency Conversion
Description
Depends on the selling channels we may need to convert the order amounts when we are creating the order in Shopify. This is required because Shopify can be GBP based however the client is selling in EUR marketplaces.
In order to implement this correctly we will need to do currency conversion.
The Shopify Store currency will be set in Shopify Connector > Shopify Currency this way we will know to what currency we will need to convert (At the moment the only supported currency is GBP).
If we would like to active the actual currency conversion logic we will need to activate Account Shopify Connector > Active Currency Conversion which is per account, this way we can decide for which accounts we would like to convert. Please note if this is activated we will also export the Shopify Connector > Shopify Currency in the payload as currency.
The Channel currency is set in Account > Exchange Rate Calculator Currency now we have and from what currency we will need to convert.
The actual currency rates will be obtained from Hmrc Rates table from where we will have to pick the most up to date rate for the Shopify Connector > Shopify Currency in order to convert the amounts into the Shopify Currency.
Once we successfully convert and create the order in Shopify we will need to store the Rate which has been used in Order Payment Shopify > Currency Rate. This way if we receive any refund afterwards we will convert them back correctly.
Please note if there are no records in Hmrc Rates table we return an error in Orders > Connector Error
| Fields Which Need to be converted | ||
|---|---|---|
| Order > Total VAT | ||
| Order > Total Tax Amount | ||
| Order Item > Item Trans Price | ||
| Order Item > Vat Item Price | ||
| Order Item > Item Tax Price | ||
| Order > Discount Value | ||
| Order Item > Vat Shipping Cost Value | ||
| Order > Shipping Sales Tax | ||
| Order > Shipping Service Cost |
Shopify as ERP Authentication and Database Structure Technical Scope
HEMISPHERE-15659 [Amazon] Settlement Report
Description
https://wearepentagon.atlassian.net/wiki/spaces/HEMI/pages/2890039313/Amazon+SP-API+Settlement
HEMISPHERE-15661 [Amazon]Additional Changes in Get Orders flow
Description
We need to start storing three additional fieds for each order.
In each request for obtaining the order we will have to add:
Get New Orders - Start storing the IsISPU node in Order > Order Type
Get Order Item - Start storing IossNumber in Order Item Amazon > IOSS and StoreChainStoreId in Order Item Amazon > Pickup Store ID
Get Order Addresses - If we have a “cancelled“ status we wont receive any shipping details in the response but in this case we wont set the order as “incomplete“ because “cancelled“ is final status,
and we want to store the order as “cancelled“.
All the additional changes are updated in the scope.
HEMISPHERE-15662 [ShopifyERP]Remove Validation for Shipping Service
Description
At the moment the Order > Shipping Service is mandatory field and we are not able to create the order in Shopify without it.
Also the field is exported as Account > Marketplace and Order > Shipping Service we concatenate both fields.
Thus we always will push some information for the service even if the Order > Shipping Service is missing.
Thus we need to remove the validation and even if we have missing Order > Shipping Service to export the order to Shopify with Account > Marketplace only.
HEMISPHERE-15668 [Shopify-Connector] Remove space before Name when exporting orders
Description
We need to check and remove for any leading white spaces in the:
Order > Shipping Buyer Name
Order > Buyer mail
Order > Shipping Street 1
Order > Shipping Street 2
Order > Shipping Country Name
Order > Shipping State Province
Order > Shipping City
Order >Billing Name
Order >Billing City Name
Order >Billing Country Name
Order >Billing State Province
Order >Billing Street 1
Order >Billing Street 2
fields when exporting an order to Shopify. If there is a space, we get an error from Shopify and are unable to create the order in Shopify because of that.
So we will need to trim any leading white spaces in these particular fields.
HEMISPHERE-15670 [Shopify-Connector] Export MP Order Id as Payment Transaction ID
Description
For some marketplaces (for example Debenhams) we are not receiving Order Payment > Transaction ID ( with type “payment“) and we get an error when trying to export the order to Shopify.
We need to create a logic when Order Payment > Transaction ID ( with type “payment“) is empty, to send the Order > Marketplace Order ID as Order Payment > Transaction ID.
HEMISPHERE-15677 [ShopifyConnector] send IOSS/ABN number as address when creating orders
Description
We need to be concating Orders Ebat → IOSS with the Orders → Shipping Street 2 as ‘address2’ when creating orders in Shopify.
HEMISPHERE-15683 [Amazon] Fulfillment Feed Warning Handling
Description
For Amazon we have the same logic as on eBay we have Error and Warnings.
Error means that the feed has been processed but the update was not successful
Warning means that the feed has been processed there is warning but sill the update is successful.
HEMISPHERE-15685 [ProSKU] Custom Scripts Automation
Description
HEMISPHERE-15691 [Puma] Shipping Error Handler
Description
If we receive any errors and have any issued during processing the files with cron_puma_203_shipment_get we will need to push notification to support_me@wearepentagon.com
HEMISPHERE-15698 [Amazon] Get Order Calculations
Description
Due to the many changes and issue with refund we will need to calculate the order amounts as follows:
Order Item > Item Price = (ItemPrice - PromotionDiscount ) / QuantityOrdered
Order Item > Item Shipping Cost = ShippingPrice
Order Item > Discount Amount = PromotionDiscount / QuantityOrdered
Order Item > Item Shipping Cost Sales Tax = ShippingTax
Order Item > Item Tax Price = ItemTax / QuantityOrdered
Order Item Amazon > Gift Wrap Price = TBC
Order Item Amazon > Gift Wrap Price Tax = TBC
Order > Order Total Amount = OrderTotal
Based on the MarketplaceId we will need to identify if the order is US or not.
US orders
Order > Оrder Subtotal Аmount = OrderTotal - All order item sum of (ShippingPrice +ShippingTax)
Rest orders
Order > Оrder Subtotal Аmount = OrderTotal - All order item sum of (ShippingPrice)
HEMISPHERE-15700 [eBay]Get Orders eBayTaxReferenceValue
Description
At the moment we are storing the eBayTaxReferenceValue as IOSS however eBay have expanded the field and at the moment we can receive it as:
<eBayReference name="ABN"> {value} </eBayReference>
<eBayReference name="IOSS"> {value} </eBayReference>
<eBayReference name="IRD"> {value} </eBayReference>
<eBayReference name="OSS"> {value} </eBayReference>
<eBayReference name="VOEC"> {value} </eBayReference>
<eBayReference name="VAT_ID"> {value} </eBayReference>
This is because for different countries we have different type of Tax.
Thus we need to start storing all different types not only the IOSS and change the field label to “Tax Reference“
Example of how we want to store it is:
ABN:{value}
IOSS:{value}
HEMISPHERE-15703 [Core] Include in the Invoice only the bundle SKU (Completecare)
Description
When we are generating invoices we are usually including all order items however if we have a bundle we need to include only the bundle SKU thus we need to add a logic where we are exporting only bundle SKUs if we have bundles.
HEMISPHERE-15704 [Puma] Get Order Shipment Amendments
Description
The cron at the moments does not add Order Shipment Row Lines and Refund Row Lines which is issue for our internal flows.
We would like to start adding order shipment row lines and Refund Row Lines when we are getting shipping updates from Puma in order the new Amazon integration to be able to ship the orders accordingly and the refund flow to be followed.
HEMISPHERE-15709 [Amazon SP]Ship Orders Feed Validation
Description
Since Amazon allows to ship an order without carrier and tracking we need to remove the validations and make the Tracking number and Courier compulsory. However if we have populated Orders > Shipping Courier we need to map it accordingly with our courier list.
HEMISPHERE-15712 [Amazon SP] Order Ship FulfillmentDate
Description
At the moment when we are shipping an order we set FulfillmentDate as current date.
However if now is later that the Orders Amazon >Latest Ship Date Amazon returns an error.
Thus we will need to add the following logic:
If Current Date is bigger than Orders Amazon >Latest Ship Date then FulfillmentDate = Orders Amazon >Latest Ship Date - 1 hour
else we send FulfillmentDate = NOW() -1 hour
If for some reason we have Orders Amazon >Latest Ship Date empty we push NOW() -1 hour
HEMISPHERE-15715 [Shopify Connector] Send 'Marketplace order ID' in additional fields
Description
It appears that the orders are not searchable via marketplace order ID in Shopify. That’s why we need to include it in the new additional field:
HEMISPHERE-15719 [Amazon] Get Order Mapping Changes
Description
We need the change the way we are storing MarketplaceId which reflects the mapping.
Orders >External Trans ID → AmazonOrderId
Orders Amazon > Marketplace ID→ MarketplaceId
Please note we need to have in mind the change for the other crons as well and the way we map MarketplaceId.
HEMISPHERE-15735 [Core] Custom stock import by MPN file split
Description
Due to the lack of resources and the big stock update files we will need to start splitting the files by 10k rows each.
For example if we have a file with 45k MPNs for stock update this will need to be split into 5 separate files.
The spited file names will be - 0{filename}, 1{filename} etc.
The original stock file will be moved to processed or error once successfully split.
Bug
HEMISPHERE-15376 [Catch] Product Get Response issue (Sportsshoes)
Description
We think there is an issue with the response reader when we send products for creation or edit because we receive an error in Hemi but on Catch the product is created and approved.
HEMISPHERE-15530 (Core) System marks automatic export as Failed even though it exports a file on the FTP [EuroCarParts]
Description
The automatic export with Automatic Feed ID 33 on EuroCarParts (https://eurocarparts.myhemisphere.com/alpha/en/record-view/1400/33) seems to be successfully exporting however it is marking the status as Failed.
HEMISPHERE-15544 [Magento2] Not exporting orders to magento or getting shippings from magento (CityChic)
Description
We are have stopped exporting orders from Hemi to Magento since 18.05
HEMISPHERE-15549 [eBay LMS] LMS Getting stuck at uploading file (Online Automotive)
Description
The LMS_REVISE_FIXED_PRICE_ITEM is getting stuck on Online Automotive since Friday. We kept on killing it during the weekend but still it got stuck. At the moment there is LMS from 21.05 which is stuck.
HEMISPHERE-15558 [CustomScript]Error returned when try to process the file (OnlineAutomotive)
Description
We have a custom script which import stock by MPN.
HEMISPHERE-15598 [ShopifyConnector] Get stock setting 0 stock only (StartFitness)
Description
There is something wrong with the Shopify Get Stock cron. All we write down is 0 stock for each product, while as you can see in the file attached (latest cron run with dev mode), there is available stock for many of the products. We noticed that all the 0 stocks got updated at 16:00 GMT on 10.06.
HEMISPHERE-15599 [PUMA] Shipping update issue
Description
On Puma FTP we have 59 files from yesterday for shipping update and we don't process them.
HEMISPHERE-15600 [ShopifyERP] Get Product Details Return Fatal Error (StartFitnes)
Description
For some reason we have 4 SKUs for which when we try to update the price we receive errors
HEMISPHERE-15619 [ShopifyConnector] Shipping cost tax percentage change from 20 to 0.2
Description
We need to to the same thing we did for the VAT percentage in the shipping tax node (screenshot of order 4767007998160 attached).
HEMISPHERE-15638 (Storesome) Creating all Product Account Storesome records only in one product when it is variation[BMW]
Description
We seem to be creating all records in Product Account Storesome in just one product when it is a variation, instead of creating a record in each Product Account that is part of the variation
HEMISPHERE-15641 [ShopifyConnector] Get shipments returns fatal error
Description
We get error when trying to get shipments
HEMISPHERE-15652 [CustomScript] Import by MPN script returns error (PartBusters)
Description
The script is returning error.
HEMISPHERE-15653 [Shopify-Connector] Not exporting address (StartFitness)
Description
We are not exporting the address for a particular order, I have re-expored the order but again on the second export there are no address parameters in the payload at all.
HEMISPHERE-15667 [Core] Displaying HTML tags instead of symbols [StartFitness]
Description
We seem to be breaking some fields when there is a special symbol (like “ or ')
A lot of SKUs in Startfitness look like this : BP5391-28" they have the “ symbol in them and when we have an order for such item , it seems to break and display the SKU in item on order like this : BP5391-28\" . This is causing issues as we are unable to export the order properly due to the system not matching this wrongly written SKU in Hemi.
HEMISPHERE-15675 [Custom Script] Stock import by MPN not working properly (Online-Automotive)
Description
Logging this as Critical as due to last weeks issues with Online Automotive (stock recalculation was not working for a long time at all) the client relationship is badly damaged at the moment
It looks like the stock import by MPN script is not working .
I have tested it with a file with only 1 MPN which has 0 quantity and it should apply 0 quantity to all SKUs related to this MPN, however the stock does not update at all in location quantity.
I am attaching the response in a file, also the stock file so you can test if needed.
HEMISPHERE-15686 [Custom Script] Stock import by MPN possibly importing case insensitively some products
Description
Could you please check if the Stock import by MPN could possibly import some products in Location Quantities case insensitively, as we had about 2.5k products on Online Automotive which were written like this in Location Quantity : 1360733-nsa1522set_rs-m44891830 while in Products it was : 1360733-NSA1522SET_RS-M44891830
This has caused issues as the stock recalculation was skipping such SKUs due to searching case sensitively.
HEMISPHERE-15695 [Custom Script] Suffix addition script creating empty file [Autofixa-sellers]
Description
The suffix addition script is creating empty files (0 bytes) after processing the stock files. The expectation is the script will process the file and add the set suffix from table 1214 and move it to a folder /Suffix_Processed/
HEMISPHERE-15743 [Core] New Stock Recalculation Returns FATAL (StartFitness)
Description
When we run the new stock recalculation we receive error
Upcoming
What can be expected next as major projects and features are:
- Shopify ERP integration additions
- Amazon Courier mapping additions
- Amazon SP stock and price flows
For more details please refer to this link or if you have any questions, please do not hesitate to contact me.
Useful links: