Logistics...

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?

bump

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,

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

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 ?

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.

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.

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

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..

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.

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