XML-Extractor

An XML extractor for products matching specific elements using regular expressions written in Python. There's a progress bar too while fetching the XML.

WHY?

I personally use this script to extract (match) products matching certain categories from an XML url containing thousands of products and get only the ones I want, the ones I select and output it in another file.

Use it to create custom (category specific) XMLs and import the products of 'output.xml' in WpAllImport.

USAGE

Change selector values: Select an element (change it to match yours) like <level3_category_description> for example and match products belonging to that category, editing the variable value of 'desired_category' in the lines below:

selectorprefix = "<level3_category_description>"
selectorsuffix = "</level3_category_description>"

and

desired_category = re.compile("My category name.*")

level3_category_description is an element of a <product> entry. Selecting that and changing desired_category string value (which also supports regex) selects the product category.

So if you want to select another category, you do so by changing desired_category = re.compile("Smartphones.*") to match your selection.

You should also change the output_file_name variable to the name of your output file because the old file will get overwritten.

Example product entry

<entry>
  <code>22301</code>
  <PerItemBarCode>22929</PerItemBarCode>
  <MUCode>ΤΕΜ</MUCode>
  <name>Product Name</name>
  <description>Product Description</description>
  <image>https://example.com/photos/e7207152345c.jpg</image>
  <level3_category_description>Smartphones</level3_category_description>
  <pricing_category>147-2</pricing_category>
  <quantity_mode_value>10</quantity_mode_value>
  <availability>out of stock</availability>
  <price>2.52</price>
  <recommended_retail_price_with_vat>2.03</recommended_retail_price_with_vat>
  <recommended_retail_price_no_vat>1.64</recommended_retail_price_no_vat>
</entry>

OUTPUT

The script will output matching products (or rather entries) in an XML file called output.xml.

Enjoy :)