Seoul Seeker Catalog: Shopee integration overview

Operator: 서울시커 (Seoul Seeker), a Korean cross-border Shopee seller using the Korea Seller Center (KRSC) with 8 shops: SG, TW, TH, MY, VN, PH, BR and MX.

App type: Seller In-house System. This is an internal tool used only by 서울시커 (Seoul Seeker) for its own merchant account and shops. It is not offered to other sellers.

Contact: ola@seoulseeker.com · Privacy Policy: https://seoulseeker.com/privacy · Terms: https://seoulseeker.com/terms

What it does

Seoul Seeker Catalog keeps our product catalog in Google Sheets and keeps it in sync with our KRSC global products and shop listings:

  1. Product Catalog. Global products and variations, with name, description, category, brand, attributes, images, weight and dimensions, global price, costs and stock movements. We edit them in a spreadsheet, and the system sends the changes to KRSC.
  2. Shop Catalogs. One tab per shop, with each listing’s local name, description, images and price. Each field is either automatic (KRSC translation and conversion) or manual (our own value, protected).
  3. Margins. The expected margin per listing in each shop, based on Shopee’s fees, the published SLS shipping rates for the product’s chargeable weight, exchange rates and our costs.
  4. Publishing. New products are created as global products and published to the shops we choose.

Every change is checked, shown in a preview and confirmed by us before it is sent to Shopee.

How it connects to Shopee

APIs used:

AreaAPIs
Auth / publicauth_partner, token/get, access_token/get, get_merchants_by_partner, get_shops_by_partner
Merchantget_shop_list_by_merchant, get_merchant_warehouse_location_list
Shopget_shop_info
Global productget_global_item_list, get_global_item_info, get_global_model_list, get_global_item_id, get_category, get_brand_list, get_attribute_tree, add_global_item, update_global_item, init_tier_variation, update_tier_variation, update_global_model, update_price, update_stock, create_publish_task, get_publish_task_result, get_publishable_shop, set_sync_field
Product (shop level)get_item_list, get_item_base_info, get_model_list, update_item, update_price, unlist_item
Media spaceupload_image, init_video_upload, upload_video_part, complete_video_upload, get_video_upload_result
Order / payment (margins)get_order_list, get_escrow_detail

Use of Google data

Seoul Seeker Catalog uses Google sign-in and Google Sheets so we can edit our catalog in spreadsheets. It asks Google only for permission to see, edit, create and delete the specific spreadsheet files it creates (drive.file). It can’t access any other files. Google data is used only to read and write those spreadsheets, is never shared or sold, and follows the Google API Services User Data Policy, including its Limited Use requirements. Details are in our Privacy Policy.

Data handling

Screenshots

  1. The Product Catalog sheet: global products and variations synced from KRSC, with sync status per row.
  2. A Shop Catalogs tab: one shop’s listings with local names, prices and expected margins.
  3. The preview shown before changes are sent to Shopee.