Import Products In Odoo

  • The TikTok Shop Odoo Connector allows you to import TikTok Shop products (listings) into Odoo. This can be a useful way to streamline your product management processes and keep your product catalog up-to-date.

  • Before importing products, it’s necessary to configure certain product configuration in the Instance.

  • Importing listings is normally the first thing you do after setting up an instance, because orders, price exports and stock exports all work through listings.

Note

Listing import is run manually from the Operations popup. There is no scheduled action for it.

Import TikTok Shop Listings

  1. Go to the Marketplaces ‣ Overview menu in Odoo.

  2. Click on the Operations button from the instance record.

    Operation View

  3. Select Import Operation and then select Import Listings option.

    Import Listings Operation

  4. The listing import operation has the following options:

    • Date Range: only the products updated between the two dates are read. Left empty, all products are imported.

    • Product Status: import only the products in one state — Draft, Pending, Failed, Live, Deactivated by Seller, Deactivated by TikTok Shop or Frozen. Leave it empty for every status.

    • Product ID: you can import specific TikTok Shop products by entering their product IDs, separated with a comma (‘,’) like this: 1729592969712207008, 1729592969712207009.

    • Update Existing Listing?: update listings that already exist in Odoo, along with their items, instead of skipping them.

    • Update Price?: also update the instance pricelist from the TikTok Shop prices.

  5. Press PROCESS button.

Note

Products in Frozen or Deleted status are reported and skipped, because TikTok Shop does not return their details.

What Happens Next

  • The import adds the products to a Product Queue Job, processed in batches. Follow it under Marketplaces ‣ Queues ‣ Queues, and see what each line reported under Marketplaces ‣ Queues ‣ Logs.

    Product Queue Job

  • A line that fails keeps its error, so the queue can be processed again once the cause is fixed — a missing attribute mapping, for instance.

For each TikTok Shop product the connector creates or updates:

  • one listing, carrying its TikTok Category, TikTok Brand, the attributes the category asks for, the package weight and dimensions, and its TikTok Status and Review Status, and

  • one listing item per variant, carrying its seller SKU.

The imported listings are shown under Marketplaces ‣ Listing ‣ All Listing.

TikTok Shop Listings

Important

  • The connector searches for existing products in Odoo based on the SKU.

  • A variant whose attribute values are not mapped cannot be matched to an Odoo variant. Map the attributes and their values before importing a catalogue that varies by color or size — see Attribute Mapping.

See also