Categories
View Replies (7)

Resolved Importing XML with parent and childs with stock

  1. Marcel
    Marcel
  2. RO CSVI
  3. Monday, 16 July 2018
  4.  Subscribe via email
Hi there, can anyone help us out with importing our catalogue and inventory?
here is our situation

Parent Product

<item>
<title>
Lichtblauw trouwpak 3 delig met gilet met revers ROKA groen
</title>
<g:id>111200293</g:id>
<g:brand>Armani</g:brand>
<g:manufacturer>Armani</g:manufacturer>
<publication_state>1</publication_state>
<g:featured_product>y</g:featured_product>
<g:description>
Mooi Licht Groen kostuum 3-delig voor de bruidegom van het merk ROKA.Het colbert heeft twee klepzakken, een borstzak, zijsplitten. De pantalon heeft steekzakken, twee paspelzakken aan de achterzijde, een knoopsluiting en een ritssluiting. Het gilet is van dezelfde stof gemaakt als het pak.
</g:description>
<g:product_type>trouwpakken</g:product_type>
<g:google_product_category>5193</g:google_product_category>
<g:mpn>18153-72 Orlando</g:mpn>
<g:image_link>https://www.roka.nl/111200293/800/1500/pep.jpg</g:image_link>
<g:link>
https://www.roka.nl/kostuum-pak-3-delig-licht-groen-18153-71-orlando-111200292
</g:link>
<price_group>3</price_group>
<price_exvat>825,6198</price_exvat>
<g:price>999.00</g:price>
<sale_price_exvat>767,7685</sale_price_exvat>
<g:sale_price>929.00</g:sale_price>
<g:availability>in stock</g:availability>
<g:condition>new</g:condition>
<g:color>groen</g:color>
<magazijn_1>2</magazijn_1>
<magazijn_2>2</magazijn_2>
<magazijn_3>2</magazijn_3>
<magazijn_4>2</magazijn_4>
<magazijn_5>2</magazijn_5>
<magazijn_6>2</magazijn_6>
<show_stock>
<![CDATA[
<style type="text/css">ul.uk-list.uk-list-divider.uk-accordion li:last-child {display: block;}</style>
]]>
</show_stock>
<g:shipping>
<g:country>NL</g:country>
<g:service>Rembours</g:service>
<g:price>0,00</g:price>
</g:shipping>
<g:shipping>
<g:country>NL</g:country>
<g:service>Ideal</g:service>
<g:price>0,00</g:price>
</g:shipping>
<g:shipping>
<g:country>NL</g:country>
<g:service>Vooruit betalen</g:service>
<g:price>0,00</g:price>
</g:shipping>
</item>

<title> : Title of the product, normal VM field
<g:id> : Product SKU, normal VM field
<g:description> : Custom field, string
<g:manufacturer> : Manufacturer, normal VM field, used in Custom Filters
<g:brand> : Custom field, string
<publication_state> : Custom field, string
<g:mpn> : Custom field, string
<price_group> : Custom field, Customfieldsforall, multiple values, used in Custom Filters
<g:color> : Custom field, Customfieldsforall, multiple values, used in Custom Filters
<show_stock> : Custom field, editor, CSS
<g:featured_product> : not used in VM
<g:shipping> : not used in VM
<price_exvat> : normal price without tax
<g:price> : normal price with tax
<sale_price_exvat> : price, without tax
<g:sale_price> : Final price, with tax
<g:availability> : not used in VM
<g:condition> : not used in VM
<g:image_link> : Image in VM
<g:image_link> : not used in VM
<g:google_product_category> : not used in VM

The parent product is created but not orderable because only sizes are. Each suit has a size, each size hat a GTIN and a unique SKU (parent SKU with size)and it has Stock. The stock is devided over our physical stores, that information is there in the feed. The Parent does not need stock as it is not orderable.

Child products (3)
Here we have 3 childs of SKU: 111200293
Child 1, the size is 46, the stock is 1 and the stock is at “magazijn 1”
Child 2, the size is 48, the stock is 4, 1 is at store "magazijn 1”, 2 are at store "magazijn 2” and 1 is at store "magazijn 3”
Child 3, the size is 50, the stock is 5, 2 are at store "magazijn 1”, 1 is at store "magazijn 2” and 2 are at store "magazijn 4”

<child>
<title>
Lichtblauw trouwpak 3 delig met gilet met revers ROKA groen
</title>
<parent_id>111200293</parent_id>
<g:id>111200293_46</g:id>
<gtin>2017000017586</gtin>
<g:size>46</g:size>
<totaalvoorraad>1</totaalvoorraad>
<magazijn_1>1</magazijn_1>
</child>
<child>
<title>
Lichtblauw trouwpak 3 delig met gilet met revers ROKA groen
</title>
<parent_id>111200293</parent_id>
<g:id>111200293_48</g:id>
<gtin>2017000017587</gtin>
<g:size>46</g:size>
<totaalvoorraad>4</totaalvoorraad>
<magazijn_1>1</magazijn_1>
<magazijn_2>2</magazijn_2>
<magazijn_3>1</magazijn_3>
</child>
<child>
<title>
Lichtblauw trouwpak 3 delig met gilet met revers ROKA groen
</title>
<parent_id>111200293</parent_id>
<g:id>111200293_50</g:id>
<gtin>2017000017588</gtin>
<g:size>50</g:size>
<totaalvoorraad>5</totaalvoorraad>
<magazijn_1>2</magazijn_1>
<magazijn_2>1</magazijn_2>
<magazijn_4>2</magazijn_4>
</child>

<title> : Title of the product, normal VM field
<parent_id> : Parent SKU to connect it to the Parent
<g:id> : Product SKU, normal VM field
<g:size> : Custom field, stockablecustomfields, used in Custom Filters
<totaalvoorraad> : Stock information
<magazijn_1> :

Our source file is an XML file or we can create multiple XML files or we can combine it, we can create any kind of field, duplicate or rename it, everything is possible. Until now, no luck.
We tried it with stockable custom fields and with multi variants. there is always an issue.

Can anyone help us to create one ore more import templates? As mentioned, we can create more than one XML import file if that is necessary.
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
Our source file is an XML file or we can create multiple XML files or we can combine it, we can create any kind of field, duplicate or rename it, everything is possible. Until now, no luck.
We tried it with stockable custom fields and with multi variants. there is always an issue.

With Stockable custom fields you need to get the format as explained in Stockable custom fields import document. That was not possible using your import template or your import XML and so we suggested to use Multi variants.

You did not mention the duplicate issues you are having with multi variants fields . I had a look at your site and your import template again. The problem is the way the value custom_override has been set, since you have two custom_title fields and you need to override the value of COM_VIRTUEMART_COLOR custom field using parent you should be setting it to N~Y, where you say not to override the first custom field but override the second one. I changed that in your template and ran the import but i am not able to test it on frontend. Can you look at your products on frontend for custom field COM_VIRTUEMART_COLOR, see if the duplicates have gone only for this custom field?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Marcel
Marcel
Accepted Answer Pending Moderation
Tharuna, You are amaizing! That's working like we want it. I want to ask you guys to help us with the rest of the import, if you want to charge us for it that's ok of course.
Can we contact to discuss the rest of the import?

Kind regards, Marcel
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
Can you explain us the issues you are having on rest of your import? We will see how we can help you with it.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Marcel
Marcel
Accepted Answer Pending Moderation
Hi Tharuna!
Here is what I know now;

1. SKU
There is a parent SKU and a child SKU. Both SKU's are shown on a child, we only want the parent SKU with the parent, the Child SKU only with a child.

2. Description
There is a field description in the import template. That's imported into the default VM Description. We Also have a group "description" with 3 fields, description nl-NL, description en-ENG and description de-DE. Can you add this field and copy the value from description into that field?

3. Stock per store
The parent is not orderable and does not have stock, only the childs (sizes) have stock. The stock is devided over our physical stores, six in total. In the feed you see <magazijn_1>2</magazijn_1>, <magazijn_2>1</magazijn_2>, etc. As an example, we have a blue suit in size 50, the total stock is 5. 2 of them are in store 1, 2 of them in store 3 an 1 is in store 5. We want to show this in the block "voorraad per filiaal" with the corresponding Child. On the parent we can do it like this; We can add stock information for all stores so if there is stock in any size it's added or we can put a global text like "choose a size first to show the stock per store"
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
1. SKU
There is a parent SKU and a child SKU. Both SKU's are shown on a child, we only want the parent SKU with the parent, the Child SKU only with a child.

I see product_sku has been used a custom field COM_VIRTUEMART_ORDERNR in your template and that is the reason you see both parent and child SKUs. May i know why this is used as a custom field when you have the value saved in product_sku field?

2. Description
There is a field description in the import template. That's imported into the default VM Description. We Also have a group "description" with 3 fields, description nl-NL, description en-ENG and description de-DE. Can you add this field and copy the value from description into that field?

You can use Field copy plugin to copy the contents from description field to description nl-NL, description en-ENG and description de-DE fields.

Stock per store
The parent is not orderable and does not have stock, only the childs (sizes) have stock. The stock is devided over our physical stores, six in total. In the feed you see <magazijn_1>2</magazijn_1>, <magazijn_2>1</magazijn_2>, etc. As an example, we have a blue suit in size 50, the total stock is 5. 2 of them are in store 1, 2 of them in store 3 an 1 is in store 5. We want to show this in the block "voorraad per filiaal" with the corresponding Child. On the parent we can do it like this; We can add stock information for all stores so if there is stock in any size it's added or we can put a global text like "choose a size first to show the stock per store"

Ok i see that you have already set these as custom fields but again the values are shown both for parent and child product on frontend and that is because in your import even parent product has been given a value instead of "choose a size first to show the stock per store" as you mentioned.

To avoid duplicates with parent and child products and with custom fields, use custom_override field for all the custom fields and set them to Y but that is possible only when you have grouped your custom fields using custom_title and custom_value fields in your import. custom_override and custom_disabler are not supported when the custom fields are set as individual columns. I also understand that you have rules set in these individual custom fields to change their values during import. So to solve your issue, you need to do two imports. First import is by grouping all of your custom fields under custom_title and custom_value columns with out using any rules to replace their values. You can then do a second import using custom table import and replace your custom fields values as needed. Let me know if this helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Marcel
Marcel
Accepted Answer Pending Moderation
Hi Tharuna!
Thanks for your reply, as mentioned before, you guys rock!
Here is my reply to your lates remarks;

1. SKU and COM_VIRTUEMART_ORDERNR
The reason is only template / front-end thing. The SKU is normally showed in a default layout position, we want to show it in the carousel dropdownlist as well. When you open the first suit and you collapse "Specificaties", you see "bestelcode", that's the SKU. Because of that we created COM_VIRTUEMART_ORDERNR, we can use field copy right?

2. Description
Good to know that we use field copy to duplicate the description to those fields. As log as we don't have translation ready, we should leave them empty.

3. Stock per store
Can you help us to make this work like you described?

Final question for now, can you please finish the project for us?
Let me know, regards, Marcel
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
Since you want us to do the import, we are thinking we would fix your rules using custom coding in an override file for product import. Roland will be sending you an email with the details.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!