Categories
View Replies (6)

Resolved Export attribute double id - bug

  1. marcinr
    marcinr
  2. RO CSVI
  3. Tuesday, 23 December 2025
  4.  Subscribe via email
Hi
Export Attribute value from Phoca
I have double ID.
I check in DB and all IDs are correct, they appear individually.

I try update the price "amount" but if i have 3 this same ID. system override...
id | alias | amount
3699 nize-prosim-zvolte-stojky 0
3699 nize-prosim-zvolte-stojky 4999
3699 nize-prosim-zvolte-stojky 7999
In my investigation.
this ID is attribute ID not unique ID. ID DB we have ID unique ;)
Please fix.
CSVI 9.3
Phoca template 9.3

example xlsx check ID and attribute_ID
Attachments (1)
import-kuba.xlsx
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please read the document Use of Group by and Sort by fields to avoid duplicate rows in export. See if this helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
marcinr
marcinr
Accepted Answer Pending Moderation
I don't need that.
Because this is fine.
I need correct ID from DB.
Yours template Phoca attribute.
ID = attribute_ID

in DB
ID ≠ attribute_ID

Screen
Attachments (1)
id-id-attrib.jpeg id-id-attrib.jpeg
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The ID in the export is the field from #__phocacart_attributes table which is the primary table for PhocaCart attributes export and is same as attribute_ID. The ID you are looking at (as per the screenshot) is from #___phocacart_attribute_values table. RO CSVI includes the fields from this table using a prefix attribute_value_. These fields can be used in both export and import. May I ask why do you want to export ID from #___phocacart_attribute_values table?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
marcinr
marcinr
Accepted Answer Pending Moderation
Because you cannot import if you don't have unique ID.

This is simple.
If you want import attribute.
attribute_id is not unique is assign to the group.
SKU is not unique is assign to the group.
alias in not unique is assign to the group.

real case example in xlsx.

Only ID in #___phocacart_attribute_values is unique and primary key.
1,2,3,4,5,6,7,8,9,10
Attachments (1)
import-update.xlsx
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In the attached patch file, I have added a new field attribute_value_id for export and import to get ID from #__phocacart_attribute_values table. This field will help you to update existing attribute values.

To get this field

1. Load the attached patch file.
2. Run update of available fields
3. You can then use attribute_value_id field in both export and import.

Try and let me know on how that goes.
Attachments (1)
patch_pc_attrbs_20251230.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
marcinr
marcinr
Accepted Answer Pending Moderation
Thank you i will be testing in the next update amount (price) or if i find some extra time :)
Regards.
  1. 3 days ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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