Dynamic Inventory values

Hi George,

In your example does the xml have a send number of fixed options e.g. 3-5 days , 5-10 days or can be it 3-10 days?

If they are fixed options, then you could use the field mapping ability: https://www.importwp.com/docs/template-fields/#mapping-fields

Otherwise adding a custom function to your theme and using that in the importer would allow you to extract and return the correct values, an example of altering dates via a custom function can be found here: https://www.importwp.com/docs/modifying-dates-using-custom-methods/

James

Hi James,

Thanks, I have one more question. Can I map the unique identifier with a custom field from my site?

For example to map the custom value (by acf) from my site that each product has one, with the SKU value from the xml?

Also here: https://prnt.sc/RjBzYd1Ra7-w at the Stock status tab there is no field mapping ability

If you toggle the "Enable text field" to allow you to import a file column/node, then the mapping field should appear.

Yes you can set the unique identifier to a custom field, how is the custom field setup on your importer, can you attach a screenshot?

"If you toggle the "Enable text field" to allow you to import a file column/node, then the mapping field should appear."

Thanks!

Currently I use this custom field https://prnt.sc/SjC0tshdEw1y

But I want to transfer this value a one that I will create with ACF.

Once you have created a field in acf, set the importer unique identifier dropdown with a custom value to the field name found in the acf admin area.

Ok, and how can I map this field from xml:

with the stock status, to display it "On backorder"

I have attached a couple screenshots showing an example xml file i used, the stock status field map and setup, and the output when imported.

This helped a lot :)

Can I leave this field empty to don't update it?

Some more questions:

1) Is there any limit at how many xmls can I use or at their size?

2) Can I update them via link every 8 hours? With ready templates

3) How does the plugin behaves with variable products and their variations?

One tricky question

4) Can I combine simple products data from xml at a single variation from the site? Maybe with a custom script?

What I need is: 

-Find the two unique ids from xml

-combine them somehow

-check if this combination exists at a simple prod or variation

-update availabilty (stock status) & combine reg & sale price. (for example here: https://fshome.gr/product/karag-walkin-2-mat-mauro/ the variation 70x70 is based on 2 simple products from the supplier 194€+194€)

+ 1 more question

Can I get notification when the xml deletes or adds a product? 

or this is out of the scope of your plugin?

You can ignore the Product SKU field from my example, that was just a simple way to identify them for me.

1. no limit to the size of xml

2. Yes you can schedule your importer to run every x hours: https://www.importwp.com/docs/how-to-schedule-an-importer/

3/4. A good example on how to import different types of woocommerce products can be found here, the examples are csv, but can easily be adapted to xml: https://www.importwp.com/docs/import-woocommerce-products-from-csv-xml/

5. What type of notification are you wanting? At the moment the history shows if products were inserted, updated or deleted, so in theory a custom script could be added to setup trigger an email or something.

Regarding 1,2 nice!

3/4) Is the question 4 possible? (add the prices of 2 simple products, at one variation)

5) yes for these 3 functions.

Regarding the unique indentifier can I map a custom field from my site (suppliercode) all products have (simple and variations) with the the sku or mpn from the XML field?

Check and map from xml this field:

with this field:

As indentifier

In regards to "3/4) Is the question 4 possible? (add the prices of 2 simple products, at one variation)" ,  can you give me an example xml file, and a desired output in woocommerce?

In regards to "5) yes for these 3 functions". , can you eloborate further what you want?

Is the screenshotted field "suppliercode" and acf field? how have you configured the import for this field?

3/4) I will provide you info later (not hurry for this)

5) I want to get a notification when a product is taken out of the xml, or a new product is imported. In the first scenario to delete it manually from eshop, at the second to create manually and then map it.

'suppliercode' is an ACF field that is used in simple and variations, I don't know how to configure this field. I want to map it with MPN as indentifier

A guide to import to acf fields: https://www.importwp.com/docs/import-advanced-custom-fields-data/

How to use an acf field as a unique identifier: https://www.importwp.com/docs/advanced-custom-fields-faq/#how-to-use-an-acf-field-as-the-unique-idenfier

I have attached a very basic custom plugin that will send an email to the website site admin when inserts or deletes are made.

Happy new year James!

I purchased the plugin, where can I find the licence?

At the plugin can I add the xml paths to export also the skus / ids / barcodes when something is inserted or deleted?

I purchased the plugin, where can I find the licence?

found it

You would need something more complex that the custom plugin i wrote, as you would need to capture the information before the item is deleted.

Ok I will try to figure it out.

Can I filter the xml fetching to indentify only products with the brand name 'Sparke'? and update only them?

There is a filter rows section on the run importer tab where you can skip rows: https://www.importwp.com/docs/how-to-filter-records-before-importing/

Yes but this skips rows from xml correct?

I want to avoid the duplicated suppliercode unique indentifier (some suppliers have the same) 

If you can give me an example couple of xml records and explain which you wish to skip i should be able to point you in better direction, but the article previously posted should solve:

filtering the xml fetching to indentify only products with the brand name 'Sparke'

For exaple this suppliercode: 1038

Is used in 2 products but I want to update only the one

This is the product that I want to be updated with the current xml: 

https://fshome.gr/product/sparke-glame-01-150/

The supplier code is '1038'

But also this product has the same supplier code 

https://fshome.gr/product/anartisi-plain-1038/

but I dont want this product to be updated by the current xml

Are you able to provide the xml/csv with these two products as an example?

Check mpn 1028 

https://sparke.gr/el/module/xmlfeeds/api?id=26 i have attached it also

The plugin used this 'suppliercode' to link with the below product:

This the product that I dont want to NOT be updated https://fshome.gr/product/anartisi-plain-1028/ that has the same supplier code

I want to search only products with the brand tax 'Sparke' from the site

MPN 1028:

<product>
        <availability><![CDATA[Available in store / Delivery 1 to 3 days]]></availability>
        <ean><![CDATA[]]></ean>
        <mpn><![CDATA[1028]]></mpn>
        <depth_cm><![CDATA[0.600000]]></depth_cm>
        <weight><![CDATA[0.000000]]></weight>
        <height_cm><![CDATA[195.000000]]></height_cm>
        <width_cm><![CDATA[100.000000]]></width_cm>
        <id><![CDATA[1315]]></id>
        <name-el><![CDATA[SLIDING SHOWER CABIN [JACORE-03]]]></name-el>
        <description_short-el><![CDATA[5L/Min]]></description_short-el>
        <description-el><![CDATA[]]></description-el>
        <name-en><![CDATA[SLIDING SHOWER CABIN [JACORE-03]]]></name-en>
        <description_short-en><![CDATA[5L/Min]]></description_short-en>
        <description-en><![CDATA[]]></description-en>
        <image><![CDATA[https://sparke.gr/97327-thickbox_default/sliding-shower-cabin-jacore03.jpg]]></image>
        <image><![CDATA[https://sparke.gr/97329-thickbox_default/sliding-shower-cabin-jacore03.jpg]]></image>
        <image><![CDATA[https://sparke.gr/97328-thickbox_default/sliding-shower-cabin-jacore03.jpg]]></image>
        <category><![CDATA[ΚΑΜΠΙΝΕΣ ΝΤΟΥΖ > SLIDING SHOWER CABINS]]></category>
        <InStock><![CDATA[Y]]></InStock>
        <price_with_vat><![CDATA[193.94]]></price_with_vat>
        <link><![CDATA[https://sparke.gr/en/sliding-shower-cabins/1315-sliding-shower-cabin-jacore03.html]]></link>
        <material><![CDATA[ALUMINIUM]]></material>
    </product>

Is there no link to the brand "Sparke" in the xml feed?

The following code would skip importing records that do not already have the term "Sparke", you would need to change the importer_id,  taxonomy, and term variables to match those that your website use (importer_id can be extracted from your browsers url when editing the importer e.g. http://iwp428.local/wp-admin/tools.php?page=importwp&edit=10&step=4 would have the id of 10):

add_action('iwp/importer/mapper/before', function ($data) {

    /**
     * @var \ImportWP\Common\Importer\ParsedData $data
     */

    // only run on a specific importer, its id
    $importer_id = 10;

    $importer = iwp()->importer;
    if ($importer->getId() != $importer_id) {
        return;
    }

    $object_id = $data->getId();
    if (!$object_id) {
        // skip because we are creating a new record
        return;
    }

    // term name to skip
    $term = 'Sparke';

    // term taxonomy
    $taxonomy = 'category';

    if (!has_term($term, $taxonomy, $object_id)) {

        // throw exception to skip importing the record
        throw new \ImportWP\Common\Importer\Exception\MapperException("Record skipped due to not having the $taxonomy: $term");
    }
});

When running the importer you would get something like the attached screenshot when

Thanks, where can I add tis code to test it?

I have added the code to the updated iwp-custom plugin, you will need to edit the php file and update the $importer_id , $term, $taxonomy variables to match those of your site.

Can I add it at the code snippet plugin instead? (so when you update the plugin nothing changes)

The iwp-custom.php file is just code specific to your site, this will never be updated by myself.

You can add the code however you want.

Hi James, can we change this: 

 // term taxonomy
    $taxonomy = 'category';

to be applied at taxonomy brands? I use this plugin for this taxonomy: https://woo.com/products/brands/

Because the category has not Sparke, but the brands have

Yes, change the category string to what ever taxonomy you are using.

you need to update all $importer_id , $term, $taxonomy variables to the values your site uses.

So this means that i will update the product only if the product_brand is Sparke ?

yes, if you only have the update permission enabled, then if the product does not have the brand "Sparke" it will be ignored.

You can confirm this is working by running the import on a small dataset of a couple that have this brand and some others that dont, then checking the importer history to see if the correct records were updated and that others show the error message: "Record skipped due to not having the product_brand: Sparke"

I tried this plugin, but It didn't return me "Record skipped due to not having the product_brand: Sparke"

I used it, but it still updated some records that are not in the brand Sparke

It looks like you have not updated the importer_id as it is still 10 (this can be grabbed from the url when editing the importer as the edit argument: http://iwpjetengine.local/wp-admin/tools.php?page=importwp&edit=6&step=4 , "6" in this example)

$importer_id = 10;

Still not working: https://staging.fshome.gr/wp-admin/tools.php?page=importwp&edit=490516&step=3 

Let take this is steps, install the following plugin, and run an importer, if the plugin is active ever history log should return "Custom Plugin Is Active" as shown in the screenshot

The importer stops at first batch or it doesn't begin now

https://prnt.sc/0QtoSVbRNXPN

When I disable it, the importer works

Can you make sure that you do not have multiple plugins with the name "Import WP - Custom code", if so remove them all and only install the latest one from the previous ticket.

Yes I had 2 plugins this is why it didn't work.

So now running the attached plugin, I got the below:

'Record skipped due to not having the product_brand: Sparke'

but also I get some notices like this:

'Record is not unique: suppliercode, Matching Ids: (345040, 154249)'

this ids are not from Sparke, the code didn't ignore them (but ignored some of them)

Can you confirm that the products (345040, 154249) , that only one of these has the Sparke brand?

I will have a look at updating the custom plugin to do its Sparke brand checks early than currently.

None of them have it:

https://fshome.gr/product/galbusera-1037-antike-skouria/

https://fshome.gr/product/anartisi-plain-1037/

That error is saying that the unique identifier is the same on both of these products, so it does not know which one to update.

None of it as they are not Sparke brand

Can you install both the attached plugins (latest pre release version of importwp and iwp-custom), making sure you only have a single iwp-custom plugin installed and activated.

This version will only update records have the product_brand Sparke.

add_filter('iwp/importer/mapper/post_exists_query', function ($query_args) {
    $query_args['tax_query'] = [
        [
            'taxonomy' => 'product_brand',
            'field' => 'name',
            'terms' => 'Sparke',
        ]
    ];
    return $query_args;
});

Make sure you also only have the update permission enabled as shown in the attached screenshot.

I got only this notice now: Not enough permissions to create record. 

So I guess it is working?

If yes, I have 1 more question:

How can I do it for more xmls with different brands? I have to use about 4-5 xmls for updating ONLY.

Insertion and deletion will only be emailed to make it manually

Yes, this will now only find existing productst that have the sparke brand

If you want to do this for more than 1 importer then you could wrap each brand query in an if statement like so (e.g. importer id 10 or 11 get diffrent queries):

add_filter('iwp/importer/mapper/post_exists_query', function ($query_args) {

    if (iwp()->importer->getId() == 10) {
        $query_args['tax_query'] = [
            [
                'taxonomy' => 'product_brand',
                'field' => 'name',
                'terms' => 'Sparke',
            ]
        ];
    } elseif (iwp()->importer->getId() == 11) {
        $query_args['tax_query'] = [
            [
                'taxonomy' => 'product_brand',
                'field' => 'name',
                'terms' => 'Sparke',
            ]
        ];
    }


    return $query_args;
});

Thank you very much, it is working perfectly!

I will come back to you some days later that I will have 2-3 more questions.

Hi,

My question now is for the insertion / deletetion of products, I tried with a test xml, but it seems that I don't recieve the email. Do I need to configuresomething else?

Also can I send also at the email a field to intentify what was inserted/deleted? (the problem here is that there is not a unique field that is used at all xmls, so I need to filter it based on xml, like the modification we did for brands. For example at xml with ID 490516 send the MPN, the xml with id 490592 send the sku field, etc) 

Does your server have a mail log plugin on it, if not can you install something like this: https://wordpress.org/plugins/wp-mail-smtp/ and then re-test if the importer is sending emails when a record is imported or deleted.

Yes I use this plugin and works normalkly for order notifications and forms

Hi George,

In the plugin code you could change the "get_bloginfo('admin_email')" to an email address instead of the site admin.

on line 36:

wp_mail('g.farmakomitis@fshome.gr', 'ImportWP Insert/Delete notification', $message, true);

If that still doesnt work let me know and i can re-test it, but it was sending an email the last time i tried.

I changed it, but still doesn't work after some tests

Hi George,

I have just tested that custom plugin on a blank install, and can confirm that it sends an email when a record is inserted or deleted.

Can you confirm that the iwp custom plugin is installed and activated.

Can you also confirm that when the import is ran there are inserts or deletes, and not just updates?

Hi james, sorry for my late reply. Didn't check it yet.

I have another issue: for some reason the import of Pam products is not working.

https://printezis.com/feed.xml

I think it happened after the recent changes of the plugins

Hi George,

Can you explain a little about what is not working?

What versions of ImportWP, ImportWP Pro and its addons are you using?

When did this stop working?

James

I use latetest at all plugins (updated them today)

https://prnt.sc/LusBDYeR6PYy

https://prnt.sc/eV2FHE93Y-I7

it returns errors, nothing is updated. 

last time I checked it, updated more that 700 records

If you go to the history tab for that importer, what are the errors?

Can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

Can you also attach your import file,

And the latest copy of your iwp-custom plugin file.

They are attached

Can you go to the history tab for that importer, and screenshot what the errors are?

https://prnt.sc/grDFgQhCNBXu

https://prnt.sc/pE401KGyEKif

One last thing, can you export your acf field group

yeap

Hi George,

Can you go to the edit screen for the first row in the csv file, "Πιγκάλ Design, Βαρέως Τύπου – Forged Copper, Pam & Co, Ø8 x H40 (cm), 2-616-933" , can you confirm that the suppliercode is set (similer to the attached screenshot)?

Can you also take a screenshot of the importer permissions page?

Thanks

Yes this is how I input the suppliercode field

Can you go to the Settings / Tools tba, and toggle the enable debug mode to on.

Then go back and run the importer.

Once complete, if you click on the "Show debug" button in the bottom right and click on the download import logs link, and attach.

ok

Thanks,

The debug log show that it is searching for a product or product variation that has:

suppliercode = "2-616-933"
product brand with the name "Pam Co"

Can you confirm that a product exists that matches this?

I realised i had the wrong importer id for my setup in your custom code, i will re-test and see if i can replicate the issue.

I found the error, it was my fault I am sorry.

I had change the name of the brand at Pam from Pam Co. This was the reason, now it worked!

Sorry again for all this, now I am trying to see the email issue

I use this plugin, but notifications are not coming (I tried an xml that after I added +2k products) still no updates.

(I tried the contact form to see if emails are working at staging and it is working)

I have added a log function into this custom script, when you run the importer and the import completes, it should write a file to the root of your website called iwp.txt

If you can run the import and attach this log file.

Just to make sure, the custom script should only send out an email when a record is inserted or delted, not when it is updated?

As the latest importer config you attached, it only had the update permission enabled, which meant it would never trigger this email.

'Just to make sure, the custom script should only send out an email when a record is inserted or delted, not when it is updated?'

Yes only when inserted or deleted (for now)

Here it is

Based on the importer log, there were no inserts/updates/deletes or skips only errors, can you view the importer history and see what the errors were?

The erros I have are these:

https://prnt.sc/G2ky9uYxdabe

but I guess that it has not relation with what is inserted or deleted from plugin, correct?

The Error Message "Not Enough permissions to create record", means that you have not enabled the create record permission on the importer and the importer cant find an existing record matching the current rows data to update so it is doing nothing.

Between these two https://prnt.sc/RyNmiqOHzCOx

I added 38 products at the xml re updated and still didn't work.

here is the iwp.txt

What else should I check?

Btw I attached the custom plugin

Based on the screenshot it has only updated 489, 504 records.

No inserts or deletes were done so it will not be triggered.

If you want inserts or deletes, you need to make sure you have enabled those permissions on the permissions step of the importer.

Sorry James I was not clear.

What I mean is something like:

1) You upload the xml 

2) It runs (and saves the last copy)

3) runs again and a new entry has be inserted (or deleted)

4) it compares the 2 xmls and it sends an email for what has been changed. (I have a code that might work for this, but in python)

So I am talking about the xmls without checking what has changed at the site.

It should work with create and delete (permissions) disabled.

Just clarify, the comparison is not what the importer does (Inserst, Updates or Deletes), it is the difference between the the latest xml file and the previous xml file and returns a xml diff?

yes

Out of curiosity what is the size of the xml files being imported?

Just to confirm the diff output would be something similar to: https://en.wikipedia.org/wiki/Diff#Unified_format

Hi George,

Using the following diff library: https://packagist.org/packages/jfcherng/php-diff , when an import completes it will compare the current file with the previous file and email a diff.

James