Logistics...

  • Posts: 17
  • Thank you received: 1
11 years 11 months ago #81949

Hi Guys,

I have setup an import routine which works well with our clients Export .csv file..

But it's not ideal, we cannot add new data to rows just change column headings really.

Basically, I used categories as:

Product type
-Manufacture
--Manufacture shortcode

Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture.

I see we have brands.. but to me that seems like the same issue...

If I had a brand code this would work great, as the name I can update manually as it will likely never change...

Any ideas?

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 11 months ago #82140

bump

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 11 months ago #82145

Hi,

"Bump" ?

Sorry, I assigned this topic to Nicolas because I don't understand your request and I have ask him if he understand more than me.
If you have more information which would allow me to understand, it would be great, otherwise Nicolas would answer you as soon as possible.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 11 months ago #82148

Basically,

I want to eliminate the showing of a 3rd level category.

Right now I have:

Products
-Tyres
--the manufacture
---the manufactures shortcode

I want to elminate the showing of the shortcode category but still show all it's products.

If I view a product list view this is fine and works.. But when I put a filter on for example category, it just reloads the category selection page??

Regards
Tony

Please Log in or Create an account to join the conversation.

  • Posts: 82818
  • Thank you received: 13360
  • MODERATOR
11 years 11 months ago #82156

Hi,

I'm not following you.
Why have the shortcode categories if you don't want to use them in your category structure ?
Just assign the products to the category names in your csv and voilà, no ?

I also don't see the problem with the filters ?

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 11 months ago #82202

Hello,

The problem is I have 10,000 products to import, so how to I assign the products to categories? the products have shortcodes so the only way I could see to import successfully was to assign the shortcodes as categories otherwise I cannot see a way of importing it successfully? If the categories had an extra field i.e. shortcode ;)

I think I have resolved the filter issue, its now only a problem trying to allow a hierarchy search, i.e. if I search category 1, show me results from all sub categories. even if this is an if no products found search sub categories.

Please Log in or Create an account to join the conversation.

  • Posts: 82818
  • Thank you received: 13360
  • MODERATOR
11 years 10 months ago #82307

Hi,

You could create a custom field of the table "product" via the menu Display->Custom fields and use that custom field column name in the column of your shortcode in your CSV in order to have the information in each product. Then, you could have a custom field filter based on that field.

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 10 months ago #82380

Edited.. Just realised we can add custom-fields to categories.

Last edit: 11 years 10 months ago by stephmor74.

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 10 months ago #82395

Umm..

The first option you mentioned about product custom field will not work. As I need to input it into a category, for example.

The export does not contain the manufacture instead it has a shortcode i.e. AV = Avon so showing shortcodes for filtering is not an option.

I thought I could use the customfields on the category to import against, instead of category name, a category customfield but doesn't like possible either..

Please Log in or Create an account to join the conversation.

  • Posts: 82818
  • Thank you received: 13360
  • MODERATOR
11 years 10 months ago #82461

Then, you could use the category namekey for the import. You can't edit the category namekey in the interface, but you can change it in the hikashop_category table of the database. Then, you can use the namekey in the categories column of the CSV to identify the categories of the products.

Please Log in or Create an account to join the conversation.

  • Posts: 17
  • Thank you received: 1
11 years 10 months ago #82472

Hello Nicolas,

That is the perfect solution thank you! It would be nice... to have a category code listed in the administration of categories and even better if you could have multiple ;)

Regards
Tony

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.076 seconds
Powered by Kunena Forum