Product Import Wizard : Expression : FUNCTION LEN does not exist
I'm trying to get from the excel file the file name except .jpg portion of it.
SUBSCRING('123-456.jpg', 1, LEN('123-456.jpg') - 4)
But the execution result is FUNCTION LEN does not exist.
Does that need to be added to the StoreManager SQL library?
Thanks, * SUBSTRING('test string', 1, LEN('test string') - 4) Thank you for contacting us and your question.
Actually, we don't work with custom application like https://msdn.microsoft.com/en-us/library/ms190329.aspx , we use MySQL which doesn't su...
How can I use custom SQL Expressions during import?
Thanks for your response.
I have a quick question, is it possible to use a SQL query that pulls data from the database and not the CSV file? Like SELECT value FROM table WHERE id = <value>?
Thanks, Hello Pablo,
Thank you for your question.
If you mean that you want to use SQL during import, then unfortunately no. There is no way to use SQL requests at Expressions fields, since import works with current database field only. Please note, that it will slow-down import if we add t...
I want to know that can to we able to manage other websites like flipkart, amazone , ebay
I want to know that can to we able to manage other websites like flipkart, amazone , ebay from your store manager module to manage our products . . ?
Thanks and Regard,
+91-8951104248 Hello Deepak Singh,
Store Manager has a built in eBay Integration addon and Amazon Integration addon (require a separate licenses) allowing to export products to eBay and Amazon.
You can find them at the Addons section of Store Manager.