Try The Advanced Import Of Products

ikoshkin · February 22, 2019, 12:00am

If you’re asking about this:

So the scenario will be
1. You import products
2. Switch to product list and select Recently updated search.
3. Select the products and apply the required categories to them like this: https://www.evernote.com/l/AQGa7HUVOttAHYE_J_R0Rud6-yloTMETLiM

Then it already works at the demo: just select a few products at once, and you’ll be able to easily add/remove categories in bulk. That functionality was introduced in version 4.9.1. So, if all products are already created in your store, and you’ve assigned the desired categories to them in bulk manually, then you can simply update quantities without assigning categories.

But if you’re asking about category mapping in the Advanced Product Import, then unfortunately I can’t say if/when it happens. It all depends on how many of our clients request that functionality.

crazyshark20 · February 23, 2019, 12:00am

Hi ikoshkin thanks to reply

I'm asking about category mapping.

I am in contact with more than one company to grow and grow more. I want them to get xml or csv out of office programs.

There are thousands of products in multiple product categories.

It takes a lot of time to add to the site, for category matching.

Because the products in the given xml and csv files exist in dozens of categories that they create according to the name they specify.

I think that the majority of people who solve this problem by developing different solutions by their own means. Example libreoffice. Add all the products into one category and then match the category names one by one by replacing them with libreoffice, and finally import them. :)

I hope that as soon as the plugin is added to the feature.

Thank you for listening.

imago · February 23, 2019, 12:00am

The most simple and practical category mapping is the following one:

Suppose your provider gives you a list of 10000 products in 200 categories. In most cases they will have some particular ID (IDP). If they don't, make a correspondence map between the provided categories and your own category IDs in the cs-cart (IDCS), like this

IDP Category IDCS

1 Books 540

2 Paintings 578

3 Books about paintings 540, 578

You can describe the imported categories by 2 or 3 of your categories, as many as you need to cover the volume of the original category

Then let CS-Cart architects only design/introduce an option to accept the catID instead of the full-path-to-the-category

adim · July 8, 2019, 12:00am

Hi,

Can you give me an option to set the price according to certain values (levels) from import file csv or xml?

Example:

Price from 0 to 10 -> mul($value, 1.50)

Price from 10 to 50 -> mul($value, 1.30)

Price from 50 to 100 -> mul($value, 1.20)

Is there any option right now to solve this situation or do you plan to do this option?

Also, I want to subscribe to the option for category mapping :-)

Thank you.

johnbol1 · July 9, 2019, 12:00am

Hi,

Can you give me an option to set the price according to certain values (levels) from import file csv or xml?

Example:

Price from 0 to 10 -> mul($value, 1.50)

Price from 10 to 50 -> mul($value, 1.30)

Price from 50 to 100 -> mul($value, 1.20)

Is there any option right now to solve this situation or do you plan to do this option?

Also, I want to subscribe to the option for category mapping :-)

Thank you.

Import quantity discounts csv

https://forum.cs-cart.com/topic/51399-quantity-discounts-updating-with-csv-import-export/

adim · July 10, 2019, 12:00am

Import quantity discounts csv

https://forum.cs-cart.com/topic/51399-quantity-discounts-updating-with-csv-import-export/

Hi johnbol1, thank you for your answer, but this add-on is not an option for me. I dont need discount for quantity, I need to add a big addition for cheap products at import from csv or xml.

Example: for products with price from 0 to 20 euro from my supplier, I want to set my addition +50%, for products from 20 to 100 euro, I want to set my addition +20%, etc. , from the same feed csv/xml. To change the prices after I make the import of products is not an option, because the feed is set up on cron job to daily update for stock (quatity) and price. So, if I change the prices after import, these will be updated in the next day with the prices from import feed.

I need an option to make this differential addition with Modifiers Functions from Advanced Import of Products add-on. I think, one option can be the possibility to use more than one function for the same import field. Example, combination of functions MUL and IF -> if($value<"20", mul($value, 1.5), mul($value, 1.2))

Do you plan to add possibility to use more than one function for the same import field? (question for cscart team)

crazyshark20 · July 15, 2019, 12:00am

No one needs category mapping?? its inreresting

jomapel · July 24, 2019, 12:00am

Hi,

Can you give me an option to set the price according to certain values (levels) from import file csv or xml?

Example:

Price from 0 to 10 -> mul($value, 1.50)

Price from 10 to 50 -> mul($value, 1.30)

Price from 50 to 100 -> mul($value, 1.20)

Is there any option right now to solve this situation or do you plan to do this option?

Also, I want to subscribe to the option for category mapping :-)

Thank you.

Hello

Someone from CS-CART member can help us with this problem?

Thank you

valid · August 13, 2019, 12:00am

Hello,

we created a feed, which runs more often, to update the stock and price of the products. The problem is that I can't map the list prices and the reduced price.

It works perfectly when importing products that have a list price and a low price. I do not know how to set the price to appear for products that are not discounted.

Prices change daily and some come in discount, others go out. Please let me know what formula I need to go to the edit box.

Thank you

teosu · August 22, 2019, 12:00am

Hi i leave simtech dev xml & CSV import addon. but advanced product import doesnt have category mapping, any news about that ? or any extra addon solution for this ?

teosu · August 22, 2019, 12:00am

also i want ask i want import just new products, and old products need only update price stock , how can i set up for this ?

crazyshark20 · August 23, 2019, 12:00am

Hi i leave simtech dev xml & CSV import addon. but advanced product import doesnt have category mapping, any news about that ? or any extra addon solution for this ?

Hi teosu i say many time but no one say anything so cs-cart team didnt work for this??

valid · August 25, 2019, 12:00am

Hello,

mapping the categories is very important. I do not understand why this option does not exist in the import module.

You cannot do complete product upload automation unless you can map the categories.

Without the possibility of mapping the categories, the import module is incomplete, and a very important component is missing.

crazyshark20 · August 26, 2019, 12:00am

if someone do or share category mapping for default addon its useful everybody

teosu · August 26, 2019, 12:00am

I dont understant nothing perfect with cs-cart , you have to pay much more custom development if you want good things… my an important bug wait almost 2 month on bug tracker …

adr · September 17, 2019, 12:00am

Hi!

Does something happened to this addon? after installing 4.10x version i get Service unavailable https://prnt.sc/p76swc

After restoring backup it works fine.

I checked file changes directory and there are some changes :

https://prnt.sc/p76x1c

https://prnt.sc/p76xis

and init.php

i cleared cache and reinstall addon again but get service unavailable again.

I even tryied to compare some of the files with older backuped version but there seem to be the same (if notepad++ is correct)

there was no work on those files so the change must have been done by upgrade.

But as i can see this addon is compatible with 4.10x

https://docs.cs-cart.com/latest/user_guide/addons/advanced_products_import/index.html

anyone knows what can be the problem and how to eventually fix it?

Thank you,

A

thetool · September 17, 2019, 12:00am

View the page source of the Service Unavailable page to see what the error is.

adr · September 17, 2019, 12:00am

I get this:

ill take look at it closely. thank you.

A

			Tygh\Exceptions\AException
	
	
		
			 
		
			 
	
	
		
			 
		
			Message
	
	
		
			 
		
			Hook fn_advanced_import_exim_get_pattern_definition_export_fields is not callable
	
	
		
			 
		
			 
	
	
		
			 
		
			Error at
	
	
		
			 
		
			app/Tygh/Exceptions/DeveloperException.php, line: 41
	
	
		
			 
		
			 
	
	
		
			 
		
			Backtrace
	
	
		
			 
		
			File:app/Tygh/Exceptions/DeveloperException.php
	
	
		
			 
		
			Line:26
	
	
		
			 
		
			Function:throwException
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.control.php
	
	
		
			 
		
			Line:115
	
	
		
			 
		
			Function:hookHandlerIsNotCallable
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.exim.php
	
	
		
			 
		
			Line:1314
	
	
		
			 
		
			Function:fn_set_hook
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.exim.php
	
	
		
			 
		
			Line:1384
	
	
		
			 
		
			Function:fn_exim_get_pattern_definition
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/controllers/backend/exim.php
	
	
		
			 
		
			Line:258
	
	
		
			 
		
			Function:fn_exim_get_patterns
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.control.php
	
	
		
			 
		
			Line:665
	
	
		
			 
		
			Function:include
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.control.php
	
	
		
			 
		
			Line:423
	
	
		
			 
		
			Function:fn_run_controller
	
	
		
			 
		
			 
	
	
		
			 
		
			File:ad.php
	
	
		
			 
		
			Line:27
	
	
		
			 
		
			Function:fn_dispatch
	
	
		
			 
		
			 
	
	
		
			 
		
			 
	
	
		
			 
		
			-->
			 
		
	




	
		
			
				Tygh\Exceptions\AException
		
		
			
				 
			
				 
		
		
			
				 
			
				Message
		
		
			
				 
			
				Hook fn_advanced_import_exim_get_pattern_definition_export_fields is not callable
		
		
			
				 
			
				 
		
		
			
				 
			
				Error at
		
		
			
				 
			
				app/Tygh/Exceptions/DeveloperException.php, line: 41
		
		
			
				 
			
				 
		
		
			
				 
			
				Backtrace
		
		
			
				 
			
				File:app/Tygh/Exceptions/DeveloperException.php
		
		
			
				 
			
				Line:26
		
		
			
				 
			
				Function:throwException
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/functions/fn.control.php
		
		
			
				 
			
				Line:115
		
		
			
				 
			
				Function:hookHandlerIsNotCallable
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/functions/fn.exim.php
		
		
			
				 
			
				Line:1314
		
		
			
				 
			
				Function:fn_set_hook
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/functions/fn.exim.php
		
		
			
				 
			
				Line:1384
		
		
			
				 
			
				Function:fn_exim_get_pattern_definition
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/controllers/backend/exim.php
		
		
			
				 
			
				Line:258
		
		
			
				 
			
				Function:fn_exim_get_patterns
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/functions/fn.control.php
		
		
			
				 
			
				Line:665
		
		
			
				 
			
				Function:include
		
		
			
				 
			
				 
		
		
			
				 
			
				File:app/functions/fn.control.php
		
		
			
				 
			
				Line:423
		
		
			
				 
			
				Function:fn_run_controller
		
		
			
				 
			
				 
		
		
			
				 
			
				File:ad.php
		
		
			
				 
			
				Line:27
		
		
			
				 
			
				Function:fn_dispatch
		
		
			
				 
			
				 
		
		
			
				 
			
				 
		
		
			
				 
			
				-->

thetool · September 17, 2019, 12:00am

It appears to be working fine on the demo so I can only assume that it's a file issue.

adr · September 17, 2019, 12:00am

what do you mean by file issue?