1. shimon
  2. RO CSVI
  3. Tuesday, 05 January 2016
  4.  Subscribe via email
Hello,

I have a template (called Product Export like Import) that exports a file with several fields in it.

manufacturer_id does not get exported. The header does not appear in the file. It is just ignored.
is there something special about this field ?
How do I get it in the export ?

Thanks
Accepted Answer Pending Moderation
Hello Shimon,
There is nothing special about manufacturer_id field, its that this field is not supported during export.
Load the attached patch file, update available fields and try doing export again.


patch_vm_2016-01-06.zip
Attachments (1)
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
Accepted Answer Pending Moderation
Hello Shimon,

Why are you using the manufacturer_id? You shouldn't be dealing with fields that end with _id because they are controlled by the database. Why not just use the manufacturer_name?

It is much safer to use the manufacturer_name field.
Kind regards,

RolandD

=========================
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. # 2
Accepted Answer Pending Moderation
Roland,

The reason that I am exporting merchant_id is because my product import imports merchant_name and merchant_id.

Should I not be doing this? Should I remove merchant_id from my import templates and just import merchant name?

What I do now is when I have a new merchant, I create a merchant is VM's backend. Then I use the name and id in the import. Is this the wrong way of doing things?
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Shimon,

The ID is not needed, CSVI will find the ID for you when you use the manufacturer_name. It is just less maintenance for you. So creating the merchant is fine, you just don't need to add the ID to your file.
Kind regards,

RolandD

=========================
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. # 4
Accepted Answer Pending Moderation
Roland,

I applied the two patches that you sent me.

Now I did a Google Base XML export (my template, not the standard one.
The export file is considerably larger than it was.

When I submit it to Google, I get 3,720 errors due to duplicated item.

If the feed remains like this Google might decide that my feed is bad and not allow it.
Please help.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Shimon,

You can read up on duplicate products in the documentation Use of group by and sort by fields. This may be of use to you.
Kind regards,

RolandD

=========================
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. # 6
Accepted Answer Pending Moderation
Perhaps I did not make myself clear.

The data base does not contain duplicate items. These 3000 items only appear once each in the db. The export never created multiple copies of these items in the past.

Now after the patches, the export is creating 3000 duplicates.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Perhaps I am not making myself clear either. I never said there are duplicate items in the database, due to the fields you are exporting a database query can return duplicate results.

They may appear duplicate in the export file, the original query they are not duplicates, one of the fields selected for the query is different.
Kind regards,

RolandD

=========================
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. # 8
Accepted Answer Pending Moderation
Got it .

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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