Resolved Products not displayed under the brand

Hello,

Don't we used any query so removed from database or some easiest way ?

There are two ways of doing the cleaning, one is that you can delete template and rules from CSVI interface as explained in previous post. Other way is you can clean it from database but before doing any of the these you need select the templates you need and download the template XML file from CSVI maintenance menu.
To clean up from database you need to the below
1. Select all the templates you need and download those templates from Backup templates option.
2. Clean all the tables associated with template. Go to phpmyadmin >> look for table #__csvi_templates >> Operations tab >> Empty the table.
3. In the same phpmyadmin >> look for #__csvi_templatefields >> Operations tab >> Empty the table.
4. In the same phpmyadmin >> look for #__csvi_rules >> Operations tab >> Empty the table.
5. In the same phpmyadmin >> look for #__csvi_templatefields_rules >> Operations tab >> Empty the table.

Once you have cleaned, you can restore the backup template XML file from CSVI maintenance menu.There is no other easy way i can think of.

Hello,

It is Long or typical way I think.. Not Getting Exactly..:P .Don't we used any query so removed from database or some easiest way ?

Thanks

Hello,

How copy rule in Rules is 3 times shows now.It confusing so much...Can you please tell me Is it possible If template deleted then rule created for the same which shows twice also deleted ? or any other way.As It is very confusing.

Also let me know what was wrong in copy rule.

The issue with copy rule was because of the same confusion of having 3 copy rules with same name. The problem is when we copy a template all rules associated with template are also copied. But when we delete a template, template fields associated with it are deleted but not rules as the rules can be shared across other templates and its fields. So even if you delete the "Final cron import testing" template rules wont be deleted. As of now, easy way would be you take a backup of your "Final cron import" template XML from CSVI maintenance menu, delete all the templates including "Final cron import" and rules and then restore the downloaded template XML file from CSVI maintenance menu. That way you have only "Final cron import" template and rules associated with it. Hope it is clear.

Hello,

Yes It seems correct now in preview section.But before importing my all products again.I need to clear the below mess up.

How copy rule in Rules is 3 times shows now.It confusing so much...Can you please tell me Is it possible If template deleted then rule created for the same which shows twice also deleted ? or any other way.As It is very confusing.

Also let me know what was wrong in copy rule.

Thanks

Hello,

As both are same ,right ?

Yes, they both are same.
Also, I found that a wrong rule has been applied to the brand field and so the manufacturer path was shown wrong. It is corrected and now category_path shows good. Can you check and confirm?

Hello,

Ya Exactly! This is happening But I am wondering why this is not happening with the template "Final cron import testing" ?

As both are same ,right ?

Hello,

I have tried this already with test file..which seems fine.But In brand i don't see Staples brand as you can see in csv there is this brand and i have checked in database Staples brand is there.But Don't know why this is not seem in Brand list.Can you check ?

The manufacturer Staples has been imported and is there in database but it is not listed in the sidebar manufacturer tree. There seems to be a limit in display of manufacturers as you can see the list is in alphabetical order and only till alphabet M is seen, there are more manufacturers in your database and not all are listed. This can be a setting in HikaShop, you may need to ask in HikaShop forum to know more on this.

Also I have Change combine field in my template that is "Final cron import" also in place of skip field under brand.But In this path become like this way : |manufacturer/37

product category/Computers/Software|product category/Electronics|product category/Office Supplies|product category/Electronics/Phones & Wireless|product category/School Supplies|product category/Electronics/Camera & Photo|product category/Department Stores|manufacturer/37

Can you have a look on it also.

Yes the field MerchantID from import file for some reason is been read and so the category is like manufacturer/37. No idea why it is reading that field. I am checking on this and will let you know.

Hello,

Also I have Change combine field in my template that is "Final cron import" also in place of skip field under brand.But In this path become like this way : |manufacturer/37

product category/Computers/Software|product category/Electronics|product category/Office Supplies|product category/Electronics/Phones & Wireless|product category/School Supplies|product category/Electronics/Camera & Photo|product category/Department Stores|manufacturer/37

Can you have a look on it also.

Thanks

Hello,

I have tried this already with test file..which seems fine.But In brand i don't see Staples brand as you can see in csv there is this brand and i have checked in database Staples brand is there.But Don't know why this is not seem in Brand list.Can you check ?

Regards

Hello,

So i think we are using wrong Brand/ this for category path and in place of that we have to use - manufacturer/

What you think on this ?

It may solve the issue.I think..But Best you Know..

Yes thats correct, can you try to change the rule 'Add path for Brands' by replacing Brand/ with manufacturer/ and try the import?

Hello,

As when i imported brands earlier in my website i used category_path for brands like : manufacturer/(Brand Name).This i read in your documentation regarding brands import.

Read Here : https://csvimproved.com/support/import/227-hikashop/1238-hikashop-brands-import

So i think we are using wrong Brand/ this for category path and in place of that we have to use - manufacturer/

What you think on this ?

It may solve the issue.I think..But Best you Know..

So Please let me know.

Thanks

Hello,
if you have manufacturer/ then there will be a new folder created and the brand names Staples, HSN will be put in there. Product categories will be added pointing to this new brand path manufacturer/Staples. can you tell me why you wanted to change to manufacturer/ from Brand/?

Hello,

Regarding : You can edit the 'Add path for Brands' rule and replace Brand/ with manufacturer/ and save it. That should do.

Can this solved the problem ??

Hello,

No..Again Same thing happening...

Can we use manufacturer/ In place of Brand/

You can edit the 'Add path for Brands' rule and replace Brand/ with manufacturer/ and save it. That should do.

Also I want to know why in rules all the rules are come 2-2 times..?

That is because there are two templates Final cron import and Final cron import testing with same type of rules. When a copy of template is installed it does create a copy of rules too.

Hello,

Also I want to know why in rules all the rules are come 2-2 times..?

Hello,

No..Again Same thing happening...

Can we use manufacturer/ In place of Brand/

Please check

Thanks & Regards

Hello,
That is because we have set the path as Brands/Staples but it should be Brand/Staples. I have corrected the 'Add path for Brands' rule. Can you please check again?

Hello Tharuna,

Thanks..

I have tried it.Preview looks good so i import the test products.

As i checked in products there is new Brands Category created for it.. :huh:

See the screenshot : http://prntscr.com/d5eeax

Which is not correct.

Can you please look that

Thanks & Regards

Hello,
i think we are almost there, i did a small modification to template 'Final cron template testing' fields, i removed the skip field which was next to brand and placed combine field in there. Skip field will skip that column in import file and the rules applied to combine field will make that column look like Brands path and wont consider the value from import file. So now the category_path and other fields looks good to me. Can you please check it and confirm? Also i did not do any import, preview looks good so i stopped there. Please try a test import with this template and let me know.

Hello,

Okay..Finally..

Waiting For Reply.

Thanks