Directory / plugin

Anything to Database Supplier Import for WooCommerce

v0.3.7 · by microcitylabsuk

Import a supplier price list (PDF, Excel, CSV, scan or photo) into WooCommerce products, created as drafts you review.

About this plugin

Import a supplier price list into WooCommerce products. Suppliers send price lists as long PDF
catalogs, Excel or CSV sheets, sometimes photos of printed pages. This plugin sends the file to
the MicroCity engine, which reads it into a table of rows and columns. You check that table in
wp-admin, confirm which column is the product name, SKU, price, description, brand and category,
and the plugin creates the products in WooCommerce as drafts.

  • Review before anything is created: the rows read from your file are shown in a table, with the
    column picked for each field (name, SKU, price, description, brand, category). Change any
    choice before creating.
  • Products are created as drafts — nothing is published without you.
  • Brand: saved as a WooCommerce brand (WooCommerce 9.6 or newer), otherwise as a visible “Brand”
    attribute.
  • Category: your existing product category with that name is used; if there is none, it is created.
  • Sizes, lengths or colours of one product become one variable product with its variations (the
    attribute takes the column’s name, or “Option” when the column has none).
  • Multi-page PDFs are read page by page; the rows join one list.
  • Products are created locally through WooCommerce functions — your WooCommerce keys never leave
    your site.
  • Uninstalling the plugin removes its settings (API key and service address).

External services

This plugin connects to the A2DB service at microcitylabs.com, operated by MicroCity
Solutions Ltd (UK). When you upload a supplier file, the file and your A2DB API key are sent
to the service so the engine can read the file and return structured product data. No other
data from your site is sent. An account (free tier available) is required.

Service terms: https://microcitylabs.com/legal/terms/
Privacy policy: https://microcitylabs.com/legal/privacy/

Plugin tags