1. imthebige
  2. RO CSVI
  3. Tuesday, 18 October 2016
  4.  Subscribe via email
Hi,

I need to know about rule ? As i have to make it for my website as soon as possible

I have categories in csv file like :

apparel,automotive,computers-software,electronics,gifts-flowers,health-beauty,hobby-collectibles,house-home,jewelry,pets,plus-size,sports,toys,luggage,intimate-apparel,shoes,tools-hardware,musical-instruments,crafts,home-improvement,diet-fitness,department-stores,office-supplies,printers,beauty-cosmetics,bed-and-bath,sports

This is in wrong way.I need them with parent category which is-> product category/ also no hyphen(-) in them, and in place of comma i need forward slash (/) as i mentioned below something like this. :

product category/4th Of July|product category/Apparel|product category/Apparel/Accessories|product category/Apparel/Apparel - Baby & Kids|product category/Apparel/Apparel - Big & Tall|product category/Apparel/Apparel - Intimate|product category/Apparel/Apparel - Maternity|product category/Apparel/Apparel - Men|product category/Apparel/Apparel - Plus/ Petite & Tall|product category/Apparel/Apparel - Teens|product category/Apparel/Apparel - Women|product category/Apparel/Shoes|product category/Apparel/Sunglasses


I have created the rule for this in rules with find and replace.But it is not working for me.Each product has parent category and subcategories

Please see the screenshot : http://prntscr.com/cvsc2u
http://prntscr.com/cvscsq
http://prntscr.com/cvsd6w
http://prntscr.com/cvsduj

Any suggestion or help will appreciate.

waiting for the reply.

Thanks & Regards
Accepted Answer Pending Moderation
Hello,

Please see the screenshots below of error messages of importing

http://prntscr.com/cwkizd

http://prntscr.com/cwkjfx

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hello,
504 error could be because the execution would have reached its time limit. Try changing max_execution_time value in php.ini file on your server and see if it 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. # 22
Accepted Answer Pending Moderation
Hello,
Also brand image url 's mapping done with which field in hika product table ?? If i add the url in csv file.

You need to use file_path field to import images.
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. # 23
Accepted Answer Pending Moderation
Hello,

max_execution_time value in php.ini file : 120

How much it will be for it to be set up more ?

and brand image url 's mapping done with which field ??

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Hello,
Hello,

max_execution_time value in php.ini file : 120

How much it will be for it to be set up more ?

Before increasing the max_execution_time, can you try setting your lines per import to 25 and see if the import finishes? If you still have issue try lowering the number, say 10 and see if it works?

and brand image url 's mapping done with which field ??

There is no field for mapping brand image url in your product import. In my previous message i meant that if you dont have a product image, you need to give your brand image url to a product directly in your import file instead of product image url. The field you need to use for importing your product images is file_path. Hope it is clear now.
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. # 25
Accepted Answer Pending Moderation
Hello,

Great..! It is working Fine now.By trying setting lines per import to 25. :)

See the screenshot :

http://prntscr.com/cwme00

Regarding brand url yes it is clear now.If there is no image for product need to add brand url in csv.

Thanks a lot..! :)

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 26
Accepted Answer Pending Moderation
Hello,

can you please give a good example to import nested categories.And the fields needs to required for it ??

Please also tell me the fields required for it.And how can i change first letter in capital of so many categories with Rule

Please reply asap.

Thanks & reagards
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
Hello,

Sorry i forgot to attach csv .Below i attached csv example for my categories to import.

Thanks
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 28
Accepted Answer Pending Moderation
Hello,
can you please give a good example to import nested categories.And the fields needs to required for it ??

The required fields for HikaShop category import are category_path and category_type. category_path will take the values of nested categories in the form of path like parent category/categorylevel1/categorylevel2 and category_type value will be product if you are importing product categories.

Please also tell me the fields required for it.And how can i change first letter in capital of so many categories with Rule

You need write a replacement rule with regular expression and apply the rule to the field where value has to be changed to capital letter.
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. # 29
Accepted Answer Pending Moderation
Hello,

Is it Possible with any way that If the image is missing then replace it with the brand image? As this is very important for my site.

Any way to do that ?? It is important for my project. because images are not there for some products if the product belongs to brand then brand image will be shown in that case.

Please reply as soon as possible.i am waiting

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 30
Accepted Answer Pending Moderation
Hello,
Is it Possible with any way that If the image is missing then replace it with the brand image?

As i said earlier for no image products you need to use your brand image url in your import csv file. I dont see any other way for doing this.
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. # 31
Accepted Answer Pending Moderation
Hello,

Thanks for the reply

yes , but mine csv is download and saved on my server from a url through curl.So i can't manually add the brand image url in csv.

I have attached a sample of my csv in which image field where url is given only in last field and other are blank.

see the screenshot : http://prntscr.com/cxgi5l

Also this csv update every day.Any suggestions ?

Regards.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
Hello,
yes , but mine csv is download and saved on my server from a url through curl.So i can't manually add the brand image url in csv.

I have attached a sample of my csv in which image field where url is given only in last field and other are blank.

see the screenshot : http://prntscr.com/cxgi5l

One way is use an default value for your file_path field in your template fields, this way CSVI will use default value when the image value is empty. One downside here is that you cant have different images urls for product with empty image value. Another way is create an override for your import routine and add your custom code to get the brand image for products with empty images. You need some coding skills or need some developer's help to do this.

Also this csv update every day.Any suggestions ?

You can use cron job to run this update everyday. Have a look at our Setting up a cron documentation.
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. # 33
Accepted Answer Pending Moderation
HI Tharuna,

Regarding : Another way is create an override for your import routine and add your custom code to get the brand image for products with empty images.

I have created the override file but in code i am not getting the brand images.Will you please help me to how to get brand images of products in hikashop ? As i need to add this in override file which i created and if you also tell to where i put the code that will be great.Means in under which function of product.php file.

Waiting for the reply.

Thanks & Regards.
  1. more than a month ago
  2. RO CSVI
  3. # 34
Accepted Answer Pending Moderation
Hello,
Look for the function processMedia on line 736 in product.php file, that is where all the image processing happens. You need to check the file_path value coming from import file and if empty write custom code to select the brand image of that product.
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. # 35
Accepted Answer Pending Moderation
Hello,

Yes i have worked as it is.But i asked about how to select the brand image of that product. Because when i add query for it

It didn't work get only one record. I need development help for this.

Below is the code which i wrote in : /home/672/public_html/administrator/templates/isis/html/com_csvi/com_hikashop/model/import/productcustom.php

$db = JFactory::getDbo();

$query = $db->getQuery(true)

->select($db->quoteName('category_name'))
->from($db->quoteName('#__hikashop_category'))
->where($db->quotename('category_type') . ' = ' . $db->quote('manufacturer'));

$db->setQuery($query);
echo "hello";
print_r($db->loadResult());

Please let me know asap

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 36
Accepted Answer Pending Moderation
Hello,

We don't provide coding solutions. Tharuna has explained in detail how to create an override and where to look. If you want us to code it for you, that will be custom work.

Because when i add query for it

It didn't work get only one record.
As with any query, if you want less records, you will have to limit it based on whichever criteria you have.
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. # 37
Accepted Answer Pending Moderation
Hi Rolandd,

Yes I know that.I just want to confirmed from you that if in mine code there is any error which is not working in csvi template.

And i followed Tharuna's answered in detail how to create an override and where to find it.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 38
Accepted Answer Pending Moderation
Hello,

As long as you fill the field with the value you want, you should be good. Easiest is to test with 1 record only.
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. # 39
  • Page :
  • 1
  • 2


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