Project Description (brief):
I am looking for a developer to create an online lingerie store on OpenCart (latest version) using a template that you propose and that fits the theme of the store.
The main task is to integrate the store with our XML product database, where one article contains up to 10 variations (color + size1 + size2), each with its own ID, price, and stock.
It is necessary to correctly assemble variations into a single product card, exclude impossible combinations, and set up automatic updates of stock and prices via cron.
Experience with XML is mandatory.
🔧 Technical Assignment
1. Website Creation
Installation of the latest version of OpenCart
Configuration of the store on the selected ready-made template
Installation of standard payment and delivery method modules
2. Integration with our database (main part)
The XML file contains the structure:
GeneralCell — main product (model, article)
Ware — variations (color, size, cup), each with its own RemQty, ID, and Price
Fragment of the real database:
<GeneralCell Name="Koza Bust Without Bone 80070 B">
<property name="Article">80070 B</property>
<Ware ID="19127" RemQty="1.000">
<property name="Color">white</property>
<property name="Size">75</property>
<property name="Size2">B</property>
<Prices><Price Price="170.00"/></Prices>
</Ware>
<Ware ID="19128" RemQty="2.000">
<property name="Color">white</property>
<property name="Size">80</property>
<property name="Size2">B</property>
<Prices><Price Price="170.00"/></Prices>
</Ware>
<Ware ID="19130" RemQty="3.000">
<property name="Color">black</property>
<property name="Size">75</property>
<property name="Size2">B</property>
<Prices><Price Price="170.00"/></Prices>
</Ware>
<Ware ID="19133" RemQty="4.000">
<property name="Color">gray</property>
<property name="Size">75</property>
<property name="Size2">B</property>
<Prices><Price Price="170.00"/></Prices>
</Ware>
</GeneralCell>
In one article, there are usually 5–10 variations.
3. How products should work
✔️ One product = one article
All Ware inside GeneralCell are combined into one product card.
✔️ Product variations
Color
Size
Cup (Size2)
Stock
Price
✔️ Availability logic
If there is 75D in the database, but no 75B — 75B cannot be selected.
Variations with RemQty=0 should be unavailable.
4. Automatic updates
Import products from XML
Update stock and prices
Add new articles and variations
Auto-update via cron
5. Required knowledge
The ideal candidate should be able to:
Work with XML structures (GeneralCell → Ware)
Understand the model: parent product → SKU variations
Be proficient in PHP + OpenCart
Write importers/parsers for data
Work with Windows-1251 encoding
6. Payment terms
Payment is made after demonstrating that:
XML is correctly connected
products are loaded
stocks and prices are updated
variations work correctly
it is impossible to select combinations that are not in the database
We had a negative experience when a website was written, modules were purchased, and then at the import stage, the person did not know how to assemble all products into cards, the database was not like that, or something else. Therefore, demonstration is mandatory.
