商品情報にスキップ
Shopify 注文マスタデータ CSV (Mmatrixify )
- 更 新 日 :
- 実装環境: Shopify
- 構築・機能・その他 / CSV、Matrixify
目次
- Shopifyの注文情報のCSV
- Mmatrixify説明のページ
- 注文情報のエクスポートとインポートの可否
- Basic Columns (基本列)
- Mmatrixify説明のページ
Shopifyの注文情報のCSV
Shopifyの注文情報は「Mmatrixify」を利用する事でインポート・エクスポートどちらも対応することが出来ます。
Mmatrixify説明のページ
注文情報のエクスポートとインポートの可否
| エクスポート | インポート | |
|---|---|---|
| デフォルトの機能 | 〇 | × |
| Matrixify | 〇 | 〇 |
Basic Columns (基本列)
| Column | Description |
|---|---|
|
ID 【新規登録】 空欄: 自動生成されます |
【1】 自動生成される注文番号 ID is automatically generated number by Shopify to identify the item. It is filled in by an Export. Can be used for Import to identify and update existing Orders. When creating new Orders, leave this value empty. Allowed Values (入力可能な値) Number Example (記入例) 11920047631 |
|
Name 【入力パターン】 空欄: 自動生成されます 入力: 任意Text入力可能 |
【2】空欄で登録すると自動生成されます 最大文字数255文字 Name of the Order to import or export. Shopify allows several orders to have the same name, however, the app uses the Name as the “key” to identify the existing order. So it works in a similar way as Handle for Products. When you are importing an order with the same Name that already exists in your store, then the app will try to update or replace it (depending on what Command you have). When migrating orders from one Shopify store to another, this Name field is the only way to tell that the order is the same as in the other store. To be safe, be sure to have your Order names unique when importing. If you need Shopify to generate the next Name automatically for you, leave the Name column empty, or delete it entirely from the import file. If you need your Order to consist of several rows, the next Order is determined when Number column value changes. The maximum length of the Name is 255 characters. If you import a name longer than that, then Shopify will cut it off at that maximum. Name cannot be updated, it can be only set when creating a new order or replacing one. Allowed Values (入力可能な値) Text Example (記入例) #1039 |
|
Command 【新規登録】 空欄: NEWと判断します NEW: 新規 【入力パターン】 NEW UPDATE MERGE REPLACE DELETE IGNORE |
インポート時の対応内容 When importing Order, it tells the app, what to do with it. ・ NEW: 新規 will try to create a new Order with the provided details. If such Order will already exist (with the same ID or same Name), then Order creation will fail. ・ UPDATE: 更新(一部項目)Allows to update some of the existing Order attributes. Here is the list of what can be updated. ・ MERGE: #の名前が一致すれば更新、なければ新規登録If the Order with that same “Name” already exists, then update it, but if it doesn’t, then create it as new. ・ REPLACE: 置き換え(すべての注文情報を削除し、シートの注文情報に登録しなおす)WARNING! Use this Command value to fully replace the whole order, not individual fields. Using this Command value, the app will delete the order from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file. If such Order with provided ID or Name exists, then the app will delete it. After that, it will create a new one. If an existing Order will not be found, then still the app will create a new Order. ・ DELETE: 注文情報の削除the app will delete the existing Order, which is found by ID or Name. If such order will not be found, then this order import will fail. This DELETE command can be very handy, when Orders need to be deleted in bulk. Here is our tutorial on how to bulk delete orders. ・ IGNORE: 無視(スキップ)the app will ignore this Order and will skip it. If no Command is specified, then the app will assume the NEW command.Allowed Values (入力可能な値) NEW UPDATE MERGE REPLACE DELETE IGNORE Example (記入例) REPLACE |
|
Send Receipt 【入力パターン】 TRUE 送信する FALSE 送信しない |
注文が作成されたときに顧客に受信確認メールを送付するかを指示。 デフォルトは FALSE (送信しない)です。 Tells whether to send Order confirmation notification receipt Email to the customer when Order is created or updated. The default is FALSE. If the Source field is set to a value subscription_contract Shopify will automatically send an Order confirmation email to the customer.フィールドが値 [subscription_contract] に設定されている場合、Shopify は顧客に注文確認メールを自動的に送信します。 There might be other Source field values where Shopify automatically triggers and sends Order confirmation notifications. See column “Fulfillment: Send Receipt” for sending fulfillment receipts. Allowed Values (入力可能な値) TRUE 送信する FALSE 送信しない Example (記入例) FALSE |
|
在庫行動 【入力パターン】 bypass 在庫管理しない decrement_ignoring_policy 在庫が０らにっても注文を受ける decrement_obeying_policy 在庫管理する |
注文があった時の在庫の動き The behavior to use when updating inventory. (default: bypass). ・bypass: 在庫管理しない Do not claim inventory. ・decrement_ignoring_policy: 在庫が０らにっても注文を受ける Ignore the product’s inventory policy and claim all amounts no matter what. ・decrement_obeying_policy: 在庫管理する Obey the product’s inventory policy. Allowed Values (入力可能な値) bypass decrement_ignoring_policy decrement_obeying_policy Example (記入例) bypass |
|
Number 【新規登録】 空欄: 自動生成されます ※動作の再確認が必要 |
注文内部番号 設定または更新することはできません。新しい注文を作成するときにIDと名前が空の場合に、ファイル内で新しい注文がどこから始まるかを判断するためにアプリによってのみ使用されます。 Order internal number. Cannot be set or updated and will only be used by the app to determine where the new order starts in the file if the ID and Name are empty when creating new Order. This field is used if you want to import multiple Orders and at the same time have Shopify generate the order Names. In that case set this field to any number for your orders so that each order gets a new number and if an order has multiple rows then those rows have the same number and are next to each other. Allowed Values (入力可能な値) Number Example (記入例) 1042 |
|
Phone 【新規登録】 注文の電話番号 |
注文の連絡先の電話番号 ※連絡がつく番号なので顧客情報と異なる場合があります。 Orders’ phone numbers – can be different from linked Customers’ phone numbers. Phone number must be full – with the country code and must be valid for the respective country. You can prefix phone numbers with ‘ (apostrophe) to allow Excel to show the + (plus) sign. But the + (plus sign) is not required. You should set the phone number in the following format: +1 23456 7890. Make sure to include the country code (in this case, +1). It is not mandatory to use a space or dash to separate the country or regional codes from the rest of the phone number, but it can help Shopify API to better detect the country code used in the phone number. Allowed Values (入力可能な値) Phone number Example (記入例) '+15417543000 |
|
Email 【新規登録】 注文のメールアドレス |
注文の連絡先のメールアドレス ※連絡がつくメールアドレスなので顧客情報と異なる場合があります。 Orders contact email – can be different from linked Customers email. Shopify is very strong about validating e-mail addresses – it is checking if e-mail actually exists in real life. If you import e-mails and get the error that the Email is not valid then first you should check that this e-mail is really correct. Allowed Values (入力可能な値) Example (記入例) someone@example.com |
|
Note 【新規登録】 注文のメモ(任意) |
注目メモ Order notes.It can be a large text going over several lines. Allowed Values Text Example Here I can write any Order notes. |
|
Tags 【新規登録】 注文のタグ(任意) |
タグ Tags allow you to add additional elements or “properties” to your order, which you can use for filtering. See this tutorial on how to bulk manage your Tags. Allowed Values (入力可能な値) Comma Separated List Example (記入例) Urgent, To Review |
|
Tags Command 【新規登録】 空欄: MERGEと判断します MERGE: 新規 【入力パターン】 MERGE 既存のタグに追加 DELETE 設定されているタグを消去 REPLACE タグを壁て置き換える |
Tageの項目に記入をしたタグをどのように扱うか Tell the app, what to do with Tags: ・MERGE: 既存のタグに追加 will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it. ・DELETE: 既存のタグを削除 will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it. ・REPLACE: 既存のタグを上書きする will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time. If Tags Command is not set, the app will assume the MERGE command by default. Tags コマンドが設定されていない場合、アプリはデフォルトでMERGEコマンドを想定します You can also have Tags listed in multiple rows within the item and with different Tags Commands. They will be executed in the same order within the item as you have them listed in the file. See this tutorial on how to bulk manage your Tags. Allowed Values (入力可能な値) MERGE DELETE REPLACE Example (記入例) REPLACE |
|
Created At Export only ※インポート不可 |
オーダーされた日を自動生成 ※注文情報を移行した場合は「移行した日時」に自動生成されます。 It will be automatically set to the time when the Order was actually created. When migrating from another store, this time will always be the time of migration. Allowed Values (入力可能な値) Date & Time Example (記入例) 2018-12-17 18:20:07 +0200 |
|
Updated At Export only ※インポート不可 |
注文情報を更新した日時に自動更新 It will be automatically updated, whenever you change the Order data. Allowed Values Date & Time Example 2018-12-17 18:20:07 +0200 |
| Processed At |
注文処理をされた日時 ※分析レポートで使用される日時。 ※インポート不可の created_at と一致。 ※APIで作成された場合のみ更新する事も可能。 The date and time when an order was processed. This value is the date that appears on your orders and that’s used in the analytic reports. By default, it matches the created_at value. When importing new order you can set this date and time and it will show in the Shopify Admin. For API created orders it also can be updated. Allowed Values (入力可能な値) Date & Time Example (記入例) 2018-12-17 18:20:07 +0200 |
| Cancelled At |
注文がキャンセルされた日時 ※キャンセルされてない場合は空欄 This column will show the time when the order was canceled. It will be empty if the order is not canceled. Allowed Values (入力可能な値) Date & Time Example (記入例) 2018-12-17 18:20:07 +0200 |
|
Cancel: Reason キャンセルの場合のみ入力 【入力パターン】 customer: 顧客が注文を変更またはキャンセル fraud: 注文は詐欺的でした inventory: 注文の品目が在庫なし declined: 支払いの拒否 other: 上記のリストにない理由により注文がキャンセル |
キャンセルされた理由 Shows the reason, why the order was canceled. It will be empty if the order is not canceled. When the order is canceled, the cancel reason will be one of the following: ・customer: The customer changed or canceled the order. ・fraud: The order was fraudulent. ・inventory: Items in the order were not in inventory. ・declined: The order was canceled because the payment has been declined. ・other: The order was canceled for a reason not in the list above. Allowed Values (入力可能な値) Text Example (記入例) other |
|
Cancel: Send Receipt 【入力パターン】 TRUE 通知する FALSE 通知しない |
注文がキャンセルされたことをお客様に通知するか Whether to send the e-mail to the customer telling that the Order was canceled. If the Order is already canceled then it will fail – because it cannot send the e-mail to already canceled Order. Allowed Values (入力可能な値) TRUE 通知する FALSE 通知しない Example (記入例) FALSE |
|
Cancel: Refund 【入力パターン】 TRUE 全額返金 FALSE 自動返金はしない |
注文キャンセルで全額返金するかの設定 When you are canceling the Order, if you set this to TRUE then this Order will be also fully refunded. Allowed Values (入力可能な値) TRUE 全額返金 FALSE 自動返金はしない Example (記入例) FALSE |
| Closed At |
注文がアーカイブされた日 This column will show the time when the order was archived. Allowed Values (入力可能な値) Date & Time Example 2018-12-17 18:20:07 +0200 |
|
Currency 【入力パターン】 JPY |
注文通貨 Currency of the Order. Allowed Values Currency code in ISO 4217 format Example (記入例) USD |
|
Source 【入力パターン】 web オンラインストア |
注文元のチャンネル 空欄にすると"Matrixify App" が作成 When exported, will have the original channel, where the order came from, like: web, pos, iphone, android, shopify_draft_order. When importing as new or replaced order, you can set any value (except the following Shopify reserved words: web, pos, iphone, android, shopify_draft_order). The Order Channel you see in Shopify Admin and Analytics will always be “Matrixify” but the custom Source will be saved in the “source_name” field in Shopify back-end (except for reserved ones). If this field is set to a value subscription_contract Shopify will automatically send an Order confirmation email to the customer.There might be other Source field values where Shopify automatically triggers and sends Order confirmation notifications. If you leave this value blank when creating the order, it will be set to “Matrixify App”. Allowed Values (入力可能な値) Text Example (記入例) shopify_draft_order |
|
Source Identifier 【入力パターン】 空欄: Matrixify App 入力: 任意の英数字 |
注文元のチャンネルの識別番号 注文を作成するときにこの値を空白のままにすると、「Matrixify App」に設定されます。 新しい注文を作成するときに設定できますが、更新することはできません。 If you leave this value blank when creating the order, it will be set to “Matrixify App”. Can be set when creating new order but cannot be updated. Allowed Values (入力可能な値) Text Example (記入例) ORDERID-123 |
|
Source URL 【入力パターン】 空欄 又は 元サイトでの注文ページURL |
元のサーフェス上の元の注文への有効な URL 新規は登録できるが更新は不可能。 A valid URL to the original order on the originating surface. This URL is displayed to merchants on the Order Details page. Can be set when creating new order but cannot be updated. Allowed Values (入力可能な値) URL Example (記入例) {URL_to_order} |
|
Physical Location Export only ※インポート不可 |
注文が処理された場所の Shopify 内部 ID。 注文履行場所とは関係ありません。 Shopify internal ID for the location where the order was processed. Not related to Orders Fulfillment locations. Example (記入例) 319135797 |
|
User ID Export only ※インポート不可 |
注文を作成した Shopify 内部ユーザー ID。 インポート時に、Shopify はインポートを開始したユーザーの ID を自動設定します。 Shopify internal user ID, who created the order. When importing, Shopify will set it to the ID of the user who initiated the import. Example (記入例) 118774735 |
|
Checkout ID Export only ※インポート不可 |
顧客が行ったチェックアウトの Shopify 内部 ID。 Shopify internal ID for the checkout that customer went through. Example (記入例) 12615473235 |
|
Cart Token Export only ※インポート不可 |
ショッピング カートを通じて開始された注文の場合自動生成。 インポート時にこの値を設定することはできません。 For orders that were initiated through the shopping cart, this will be the reference to the cart from which the order was created. When importing, this value cannot be set. Example (記入例) 68778783ad298f1c80c3bafcddeea |
|
Token Export only ※インポート不可 |
トークン キー。Shopify システムで注文を識別する方法。 Shopifyで自動生成。設定不可。 Token key, how the order is identified in the Shopify system. It’s unique to all stores. You cannot set its value, it is always set by Shopify. Token is used in the Order status URL. Example (記入例) 11a70068657e9f32ddcd11b7da8d797c |
|
Order Status URL Export only ※インポート不可 |
顧客がShopifyの注文ステータスを確認できる URL The URL, where a customer can view their order status. Example (記入例) https://checkout.shopify.com/20255113 /orders/11a70068657e9f32ddcd11b7da8d797c |
| Weight Total | Total weight of the ordered items, in grams. Can be set when importing new Orders. Cannot be updated for existing Orders. Example (記入例) 4000 |
|
Price: Total Line Items Export only ※インポート不可 |
Total price of all line items. This is calculated from actual line items, and cannot be set as a value in the import.Example1200 |
|
Price: Current Subtotal Export only ※インポート不可 |
Current value of the order, including discounts, but before shipping and taxes, after any order edits, refunds and returns. Example (記入例) 1000 |
|
Price: Subtotal Export only ※インポート不可 |
Value of the order, including discounts, but before shipping and taxes. Example (記入例) 1000 |
| Tax columns | Whole order-level tax columns. When importing order-level tax, Shopify will automatically split it between taxable line items. If any Line Item or Shipping Line has tax applied in the import file, then order level tax will not be imported to avoid duplicating taxes. You can have up to 100 different taxes applied. If the order has multiple rows, taxes will only be taken from that order’s first row. Tax title/name columns: Tax 1: TitleTax 2: TitleTax 3: Title… Tax 100: TitleExample (記入例) VAT Tax rate columns: Value 1 = 100%Tax 1: RateTax 2: RateTax 3: Rate… Tax 100: RateExample (記入例) 0.21 Tax amount columns: Tax 1: PriceTax 2: PriceTax 3: Price… Tax 100: PriceExample (記入例) 210.00 |
| Tax: Included |
Cannot be updated, it can be only set when creating a new order or replacing one. Tells whether the order subtotal has taxes included or not. If set to TRUE then taxes will be visible in the admin, but not added to the orders total.Allowed Values (入力可能な値) TRUE FALSE Example (記入例) TRUE |
| Tax: Total | Total amount of the tax applied to the order. When importing Order level tax then this will be the amount that Shopify adds to the Order Total in Shopify Admin. If left empty then app will calculate total tax for you. Does not have any effect on Order Total if importing Line Item and/or Shipping Line level taxes. Example (記入例) 300.43 |
|
Price: Total Discount Export only ※インポート不可 |
Orders total discount amount. Example (記入例) 1.24 |
|
Price: Total Shipping Export only ※インポート不可 |
Orders total shipping amount. Example (記入例) 6.82 |
|
Price: Current Total Duties Export only ※インポート不可 |
Orders current total duties amount in the shop currency. Amount after order edits, returns, and refunds. Example (記入例) 1.22 |
|
Price: Total Duties Export only ※インポート不可 |
Orders original total duties amount in the shop currency. Example (記入例) 1.49 |
|
Price: Current Total Fees Export only ※インポート不可 |
The current total additional fees on the order in the shop currency. The amount values associated with this field reflect order edits, returns, and refunds. Example (記入例) 3.34 |
|
Price: Total Fees Export only ※インポート不可 |
The original total additional fees on the order in the shop currency. Example (記入例) 3.85 |
|
Price: Total Refund Export only ※インポート不可 |
Orders total refunded amount. Sum of all successful refund transaction amounts.The sum will not convert transaction currencies – it will only be the sum of the amount. Contact Matrixify support if the value is needed in shop currency instead. Example (記入例) 201.24 |
|
Price: Total Outstanding Export only ※インポート不可 |
The outstanding balance on the Order. Example (記入例) -4.84 |
|
Price: Current Total Export only ※インポート不可 |
Orders current total. The value of this field reflects order edits, returns, and refunds.In Shopify Admin you see this value as the Orders Total which might be different from the Orders Original order value.Example (記入例) 1099.18 |
|
Price: TotalE xport only ※インポート不可 |
Total amount of the order, including line items, discounts, shipping cost, and taxes. If Order has been edited then the value in Shopify Admin will be displayed as Original order value, not Total.Example (記入例) 1300.43 |
| Payment: Status | Financial status of the order. Will be one of the following: ・pending: The finances are pending. Payment might fail in this state. Check again to confirm whether or not the finances have been paid successfully. ・authorized: The finances have been authorized. ・partially_paid: The finances have been partially paid. ・paid: The finances have been paid. ・partially_refunded: The finances have been partially refunded. ・refunded: The finances have been refunded. ・voided: The finances have been voided. When importing new order, you can set this value, but this will just mark the status on Admin, however, it will not generate the respective Transactions or Refund Transaction, so the “Paid by customer” will show 0.You cannot update this field for existing Orders, for that import actual transactions. To have the amount visible in the “Paid by customer” you need to add the respective “Transaction” or “Refund” lines. By default, it is set to “paid”. Allowed Values (入力可能な値) pending authorized partially_paid paid partially_refunded refunded voided Example (記入例) paid |
|
Order Fulfillment Status Export only ※インポート不可 |
Summarized status of the order fulfillment. Will be one of the following: ・<empty>: There are no fulfillments done on the order yet. ・partial: Order is fulfilled partially, meaning that at least one item has been shipped. ・fulfilled: All line items are fulfilled or returned. There is nothing more to fulfill. ・restocked: All line items in the order have been restocked. To import Order with a certain Fulfillment Status, you need to create Fulfillment Lines and fill in Fulfillment columns. See documentation further. Tutorial – Bulk Unfulfill your Shopify Orders – cancel those Fulfillments. Tutorial – Fulfill existing Shopify orders in bulk. Allowed Values (入力可能な値) <empty> fulfilled partial restocked Example (記入例) fulfilled |
| Additional Details | Additional details collected on the order from the customer – either from the product page or from the checkout page. Each added property will be shown as “<name>: <value>”, and will include all of those properties as several lines inside the Excel cell. When prepared in the same format, those details also can be imported. Those are visible in Shopify Admin, on each Order, section “Additional Details”. This section shows only if there are any details added, otherwise it’s not visible there. ・ ・Read more about collecting additional data for orders:Collect information from your customers with cart attributes By default app will export each name: value combination in a new row. If you need to change new line to a different symbol to separate different name: value combinations reach out to our support.Allowed Values (入力可能な値) Lines of name: value Example (記入例) Gift wrapped: yes Door code: 1234 |
|
Purchase Order Number Export only ※インポート不可 |
The purchase order number associated to this order. Example (記入例) PO#123456 |
Mmatrixify説明のページ
Matrixify アプリを利用するとインポートすることが出来ます。
※Matrixifyをご利用の場合も一部エクスポート限定でインポートすることが出来ない項目があります。
更新日:
利用環境: Shopify
