Product Import
FTP Upload Time - 5am
File Name: ECOMITMD
File Criteria:
All Active Items
All X-Lines that Total INV does not equal 0
16/09/21 The CN DC Inventory was mapped to the FC (Store 2822) On hand Inventory.
Retail Price File Column Headers
Order | Column Name | Description | Example |
0 | skn | SKN | 14079 |
1 | vendor_name | Vendor Name | VENDERMAC DIST. P/L-CONS |
2 | mpb_name | MPB Name | MARVEL |
3 | as400_mfr_number | MFP Number | SSWP01 |
4 | item_status | Item Status | 1 |
5 | buyer_number | Buyer Number | 6 |
6 | cetegory_number | Category Number | 63 |
7 | sub_category_number | Sub Category Number | 22 |
8 | retail_price | Retail Price | 0.99 |
9 | cost_price | Cost Price | 0.63 |
10 | as400_height | Height | 16 |
11 | as400_width | Width | 21.5 |
12 | as400_length | Length | 0.5 |
13 | first_dc_receipt_date | First DC Receipt Date | 20170228 * |
14 | [N/A] | Last Price Change Date | 20190628 * |
15 | dc_inv | DC Inventory | 0 |
16 | open_pieces | Open Order Pieces | 0 |
17 | sim_code | License | SM |
18 | currency_code | Currency Code | 10 |
19 | total_as400_inventory | Total AS400 SOH | 206 |
Barcode Import
FTP Upload Time - 7pm
File Name: ECOMUPC
File Criteria:
All Active & X-Lines
and/or Modify date is within last 365 days
Price Import (Split Jobs)
FTP Upload Time - 3am
File Name: ECOMPC
File Criteria
All Active or X Items with a Session update in last 30 days
Then pull the CURRENT Retail for the SKN with a session update, not the price on the date of the change
11/03/21 Discovered MY has higher priced sub-markets for some stores. Submarkets were appearing on the PC import, so going to update report so it excludes all stores (not online store) so it will only do price changes relevant to online → Zendesk Ticket #82698 for reference
13/08/21 It was discovered that the online store only (submarket) retail price is not picked up and imported in the weekly product import. The logic has been update and the retail price and online store only (submarket) retail price (if exist) will be imported in the weekly product import for all the markets.
Status Import (Split Jobs)
FTP Upload Time - 12.30am
File Name: ECOMSTAT
File Criteria:
All Items with a session update in last 30 days
TPR Price Import
FTP Upload Time -
2.00am, generation starts at 1.15am, file will be uploaded to SFTP at 1.45am
3.25pm, generation starts at 3pm so TPR’s must be in before 3pm
9.25pm, generation starts at 9pm so TPR’s entered after 3pm can be captured and imported
File Name: specific TPR name for market
File Criteria
All Active TPRs sorted by TPR price highest to lowest
For some more detail on pricing & TPR’s in the PIM, view here: Regular Pricing & TPR Pricing
Singapore & Brunei Specific
Promotions in SG & BN
All Singapore Stores
+
4228 Brunei Online Store – to appear online
+
Current process for auto-d promotions in-store for BN
Online Only Promo SG + BN
4216 Singapore Online Store
+
4228 Brunei Online Store
The TPR file for Brunei will pick up TPRs for Store 4228
Inventory Import
FTP Upload Time - 3am to SFTP → 25/01/21 moving to upload time of 3.25am
File Name: SOH
File Criteria:
All Active (item status 1) items
All X-line (item status 2) with inventory
On the 19/08, if an item in BN 4215 Store first DC receipt date is less than 30 days, it will not be sent on the FULL and DELTA inventory files for SG
.delta Inventory Import
Delta Live for All MKTs
Delta file sends every hour to Comestri
SGP, HKG, CIN - Delta update for store sales only update 3 times a day (4.15, 9.15, 23.15)
TWN, MLY, THA - Delta update for store sales can be updated hourly but the function hasn’t been tested and enabled.