Best Beer Japan

Initial Setup

Create a Best Beer Japan shop

Navigate to Sales & Distribution > Settings
In Shop Settings section click and select New BBJ Shop
Input Description, check the Currency, Country and Taxes included inputs are as expected
Click

Import and track Products

Import products

Download the Products CSV from Best Beer Japan
Navigate to Sales & Distribution > Settings > Shops > BBJ > Import Products CSV
In the Import section, click Browse... and select the Products CSV file
Click button
Select the products you wish to import
Double check the Product Type select is correct (Beer)
Click

Track products

Navigate to Sales & Distribution > Sales Centre > Shop Products
Select the BBJ shop from the Shop select
Uncheck the ⚠️ button if it is depressed to show all products
Open a Shop Product
From the select input, find the corresponding Product Catalog Product for the Shop Product and click Start tracking
For each Variant, click the button.
The SKUS must match to be able to track inventory. If there is a mismatch, fix the SKU in BBJ, download the CSV, and re-import the products. This will update the SKUs.

General Information

Customers do not come with a unique ID, so we match by (N) 店舗名 (Store Name).
THIS MEANS IF A CUSTOMER ORDERS FROM A DIFFERENT STORE NAME, A NEW CUSTOMER WILL BE CREATED

The intended workflow for importing orders is

∗Export products csv from Best Beer Japan
∗Import products csv into BrewKeeper
Found in Sales & Distribution > Settings > Shops > BBJ > Import Products CSV
∗Track BBJ product inventory
Link BBJ Shop Products to the Product Catalog in BrewKeeper
Export orders csv from Best Beer Japan
Import orders csv into BrewKeeper
Found in Sales & Distribution > Settings > Shops > BBJ > Import Orders CSV

∗Steps 1️⃣, 2️⃣, and 3️⃣ only need to be done once, unless you add new products to Best Beer Japan and need to import them.

Deleting a BBJ Shop Variant / Shop Product in BrewKeeper

You can delete any BBJ Shop Variant or Shop Product in BrewKeeper. If you import a CSV with the same external IDs of those you have deleted, they will be un-deleted.

The reason being, there is no indication in the CSV that a product has been deleted in BBJ.

Shop Variant vs Line Item Pricing

Example:

Shop Variant 販売価格 = 9040
Order Line Item 価格 = 9944

The Shop Variant price is the price BEFORE tax is added.

Products CSV Import

Creating Shop Products

Best Beer Japan		BrewKeeper
`商品ID`	→	`ShopProduct.external_id`
`商品規格ID`	→	`ShopVariant.external_id`
`商品名`	→	`ShopProduct.title`
`商品コード`	→	`ShopVariant.sku`
`規格分類1(名称)`	→	`ShopVariant.title`
`販売価格`	→	`ShopVariant.price`

CSV Columns

(A) 商品ID (Product ID)

1
2

(B) 公開ステータス(ID) (Publication Status ID)

1

(C) 公開ステータス(名称) (Publication Status Name)

公開 (Published)

(D) 商品名 (Product Name)

【樽】一期一会 (セゾン / 5.0%)

(E) ショップ用メモ欄 (Shop Memo)

(F) 商品説明(一覧) (Product Description)

(G) 商品説明(詳細) (Product Description - Detailed)

(H) 検索ワード (Search Keywords)

(I) フリーエリア (Free Area)

(J) 商品規格ID (Product Specification ID / Shop Variant ID)

(K) 販売種別(ID) (Product Type ID)

1

(L) 販売種別(名称) (Product Type Name)

販売種別A (Beer)

(M) 規格分類1(ID) (Specification Category 1 ID)

1

(N) 規格分類1(名称) (Specification Category 1 Name / Shop Variant Title)

10L

(O) 規格分類2(ID) (Specification Category 2 ID)

(P) 規格分類2(名称) (Specification Category 2 Name)

(Q) 発送日目安(ID) (Shipping Date Estimate ID)

2

(R) 発送日目安(名称) (Shipping Date Estimate Name)

1～2日後 (1-2 days later)

(S) 商品コード (Product Code / SKU)

BIGI25-KL10

(T) 在庫数 (Stock Quantity)

9

(U) 在庫数無制限フラグ (Unlimited Stock Flag)

FALSE

(V) 販売制限数 (Sales Limit)

(W) 通常価格 (Regular Price)

(X) 販売価格 (Sales Price)

9040

This is the price BEFORE tax is added, so on the Order line itemit would be 9944