Import of goods from CRM feed into WordPress + WooCommerce

Content Management Systems, Databases & SQL — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

There is a site on WordPress + WooCommerce
From the CRM, there is a feed/export with products in the following logic:

“Parent” product: DO1111 (without size)
Separate items by sizes: DO1111-S, DO1111-M, DO1111-L …
Size is always in SKU after the dash (-S/-M/-L/...)

Problem: WooCommerce currently shows each size as a separate product.
It is necessary to find the best solution and make it so that the feed automatically collects into one product card with size selection
Data that needs to be synchronized (minimum):

Main SKU (DO1111)
Variation SKU (DO1111-S)
price
stock/availability
name/description/category/photo

Do not create duplicates:
- when re-running the import — update existing products/variations
- if the size disappears from the feed — set the variation to “out of stock” or hide it (to be agreed)

Proposals 9 Discussions 2

Ilya Silantyev

1 0

Projects -
Rating -
Rating 539

Budget: 7000 UAH Deadline: 3 days

Hello!
I can implement automatic assembly of variable products in WooCommerce from the CRM feed: the "parent" product is created as one card (DO1111), and the size options (DO1111-S/M/L…) are imported as variations with size selection.

Import without duplicates: repeated runs update existing products/variations by SKU (price, stock/availability, name/description, categories, photos).
If a size is missing from the feed — we automatically set it to "out of stock" or hide it (as agreed).
If the SKU is not yet on the site — the product is created automatically (we can either publish it immediately or save it as a draft).

To accurately assess the work, please let me know the format of the feed (CSV/XML/JSON/API).

Ihor Leontiuk

17 0

Budget: 4000 UAH Deadline: 3 days

Hello!
The task is clear. Here, it is necessary to work correctly with the wp_posts and wc_product_meta_lookup tables to properly link variations with the parent product.

I will implement an import mechanism that:

- Determines the Parent SKU using a regular expression (regex) up to the first dash.
- Checks for the product's existence in the database before writing.
- Updates only the changed fields (price, stock) to avoid overloading the server.
- Resolves the issue with missing sizes (sets stock_status = 'outofstock').

I guarantee that photos and categories will be correctly associated with the parent product.
Execution time: up to 3 days (including testing on the dev copy).

Vitaly But

80 1

Budget: 2600 UAH Deadline: 3 days

Trust a professional with over 10 years of experience! The rate and deadlines are current! I will be happy to collaborate! Experience in commercial development of online stores on CMS, business portals, and corporate websites - 11 years! +CMS: WordPress(+Woocommerce) PrestaShop/Opencart/Joomla/Bitrix/MODX/DLE/Shopify php/html/css/js/Mysql, PhotoShop/Figma Examples of work (from scratch, turnkey): https://amari.net.ua/ https://heypretty.gr/ https://wildandorganic.com/ https://cryptosignals.org/ https://ecnbot.com https://locs-ua.com/ https://www.grower.com.ua/ https://www.alternativemedicine.com.ua/ https://silkkiss.ua/ https://v12coffee.com.ua/ https://smrtalgo.com/ https://sengero.no/ https://beautybysim.no/ https://sonatagalleri.com/ https://www.solmy-realestate.com/ https://www.emmanuel.com.ua/ https://www.onsitecomputersinc.com/ https://express-tehbud.com/ https://korostenporcelain.com.ua/ https://sladok.com.ua/ https://pricemds.com/ https://picupmedia.com/ https://www.serasar.com/

Nazar K.

56 0

Budget: 3500 UAH Deadline: 2 days

Good day, I am interested in your task, let's discuss the details in the chat.

Kseniia Melnik

1 0

Projects -
Rating -
Rating 289

Budget: 3000 UAH Deadline: 3 days

Hello! I have read the task carefully — the problem is clear: currently, WooCommerce perceives each SKU with the suffix (-S/-M/-L) as a separate product, and it is necessary to automatically gather them into one card with variations from the feed. I have experience working with similar logic (feed imports, variable products, SKU synchronization) and can offer an optimal solution so that the import correctly creates/updates variations without duplicates. I can also test on a small sample to ensure that everything works stably. I am ready to work for the minimum rate — I am currently building my rating. I will be able to provide the exact cost after familiarization.

Valerii Mozghovy

0 0

Projects -
Rating -
Rating 228

Budget: 1111 UAH Deadline: 1 day

Hello, Alexander!
I specialize in the implementation, configuration, and technical support of CRM systems for over 6 years, as well as performing integrations with websites and other services.

I have reviewed your task — I will be able to provide an exact cost and timeline after clarifying a few details about the project.

I guarantee quality implementation and stable operation of the system.

Kyryl Shcherbyna

24 0

Budget: 9000 UAH Deadline: 2 days

Good day!
I have reviewed the task description and the logic of the feed. I have already implemented similar cases with WordPress + WooCommerce and importing from CRM, the task is clear.

Currently, WooCommerce perceives each item with a separate SKU (DO1111-S / DO1111-M / DO1111-L) as a separate product. It is necessary to automatically combine them into one variable product card based on the base SKU (DO1111) with size selection.

2–4 working days
(depends on the format of the feed and the current import method)

I will be able to name the exact amount after reviewing:

the format of the feed (XML / CSV / API)

the method of current import

whether admin configuration or logging is needed

I am ready to quickly connect, look at the feed, and propose the optimal solution specifically for your system.