GeekoDev 6 years ago

If you want to add a space you just have to do it in 2 steps, first add an append function with manual value and insert only the space ' ', then add another append function and add your barcode field.

GeekoDev 6 years ago

Indeed, can import/export product options, there is a lot of parameters to be able to import all kinds of complex option setups.

The module is easily capable to handle extra columns into product or product_description table. It will also be able to insert data into extra tables if you have a module made to handle the data into normal product edition, because the module will use the default opencart function to import the product so if you have a 3rd party module that is handling its data from normal product insert/edit then you can use custom fields in import step 3 to bind any import data to these tables from your 3rd party module.

For options it is a bit more complicated as it could be very specific, the module is made to handle some of common extra fields into option table (sku and upc) but it could require a bit of tweaking to make it handle other ones, I will try to make some function to be able to set up any custom field into product option table too.

GeekoDev 6 years ago

You're welcome, thanks for your great comment :]

GeekoDev 6 years ago

Yes it works on all versions of ocstore.

GeekoDev 6 years ago

Set up the extra function skip to skip item if image is equal to "" (nothing).

austurki@gmail.com 6 years ago

hi alexandre
i must put "" only without (nothing) yes?

GeekoDev 6 years ago

In fact just put nothing in the field, not even the quotes, just let it empty.

GeekoDev 6 years ago

In step 1 select import mode: "Product quick update".

GeekoDev 6 years ago

Hi, yes this is possible, you can do that in Step 3 > Extra functions > Wholesale price multiplier.
In your case you can configure it like this:
10:0.1
20:0.5

GeekoDev 6 years ago

Indeed, you can use the extra function "Skip on import value" for that.

austurki@gmail.com 6 years ago

ooooh thanks...this can do in same field with comas or i have to create one function for each category?

GeekoDev 6 years ago

On this function it is necessary to create one function for each value.

GeekoDev 6 years ago

This is not possible in default opencart, maybe some extensions can do that.

GeekoDev 6 years ago

3. It is very easy to use, just select a field where you have a value that refers to a product (can be product id, product name, model, upc, sku, etc) and the module will automatically set this product as related.
4. Not sure to understand this one, I contact you on mail to check that.
5. Select "Order" in export type, all order data is included.
6. You mean if you don't have the options separated but only in product name like "T-shirt green" and "T-shirt blue" ?
This is quite difficult to handle because the color value is not separated from product name, in such case the only way to handle that is to set up an extra function "conditional value" to detect the color and save it in an extra field, and then use this extra field as the option. It works fine but you have to list all possible colors in conditional values because it is not possible to detect it automatically in other way.

GeekoDev 6 years ago

Hi,
1. Use extra fonction "conditionnal value", set it like this:
~(dress):Dresses
Which means if dress word is found in current field, then replace this field by Dresses
2. Use import label to handle that, if you need to remove from only one supplier then set an import label for each of import, if you want to remove all products that are in both of these import then set the same import label for both.

austurki@gmail.com 6 years ago

good morning alexandre
1000 thanks for your care :)
regardaing
1-i try to do it but cant do
in my case
product name
https://goo.moda/2-piece-incili-vest-tunics-indigo-02-6039
i have category
<category_path><![CDATA[TUNICS]]></category_path>
i want any product contain in name "tunics" to change its category from "X category" to "tunics" category...how to do?
2-what do you mean by "import label " i couldnt find it!

GeekoDev 6 years ago

1. - Create custom field "category" in step 2
- Use extra fonction "conditionnal value", set it like this: ~(tunic):Tunics, and make it to save into the custom field category
- bind this custom field as your category field
2. Import label can be set in step 4

GeekoDev 7 years ago

You're welcome, thanks for your great comment :]

GeekoDev 7 years ago

Hi, the module is exporting all data that comes in the getProduct function, normally the 3rd party modules are inserting their data inside this function so it should be exported too.

ertinet 7 years ago

Its not the Opencart native fields... How can I add oter filds from other tables ?

GeekoDev 7 years ago

Yes, but 3rd party module are normally adding their data into the default opencart function to get a product because the data must appear on product edit page in admin, if you see your 3rd party module data in product edit page then my export tool will include this data in the export.

GeekoDev 7 years ago

Hi, you can use the extra function "Prepend", so you set it to add "XY" to the product code field of your import file and then all your product codes will have the XY before the code.
A lot of transformations can be done using extra functions :)

Azraell3538 7 years ago

Hi GeekoDev,
i am not developer therefore can be my questions stupid. But i didn't understand that this function should to add in code page or in admin page?
If i understood true that this function can be use by product code in Step3 as like preperend(XYZ)-product code? isn't it?
i use only one precode. "FHB".
2. Question: If i own category in my website and i down't want to use import category, can be disable category choose by import and can be import only according to Product code or SKU?

Many thanks

GeekoDev 7 years ago

Hi,
1. Yes prepend can be used on any of your import fields. If I understood well you have for example a file to import with this data:
code;name;[...]
1234;Some product;[...]
And you want that the code to be FHB1234 instead of just 1234, that's right? if so yes the prepend function is made for that.
2. Yes, there is a feature in the module to handle such cases easily, it is the "Category bindinds" in step 3 > extra functions, with that you can choose to which category should go the product based on a value in your import file.

Azraell3538 7 years ago

Hi,
1- if i understood well, i should do so:
in Step 3:
under data tab should i add
Product code : FHBcode
thats all?
How can apply this prepend function in extension?

GeekoDev 7 years ago

I make you a screenshot for understand better: http://prntscr.com/kxmir2
Tell me if this is what you want to do.
The extra function will apply a transformation to a field into your import file, then you can choose to import that code FHB1234 to product model, sku, or any field you want.

GeekoDev 7 years ago

Hi,
Yes the Category bindings feature is made for that. All you have to do is to set up what is the category node in Step 3 > Links, then go to Extra functions > Category bindings, click on Refresh category list (it will detect all categories in your actual feed), and then you will be able to set to which of your opencart categories you want to bind them.
If you want to bind only 1 category but want the rest to be created as they appear in the feed then just bind the wanted category and let the others empty.

ofzswi 7 years ago

@ddonkey
Buy it :) I'm using it and you can do anything with it! It would be also possible if you're using "replace". Replacing the word "Toys" with "Games". Products in Import which are connected to Toys Category will change to Games.
Or of course Category Binding :)

Zeusy123 7 years ago

Hi there, Alex still on vacation and you have been waiting on answer for 13hours so I'll reply for you:

1 = Yes
2 = Yes
3 = never seen this problem in live versions, and its certain not a beta:)
4 = I have a few 65k sites and it imports in about 4.30mins but it really is dependeant on the feed quantity, speed of server youy are downloading images from and speed of your server and db.

Anyways, hope that is helpful :)

GeekoDev 7 years ago

Hi, thanks Zeusy for the answers, that's right.
About 3) it is an error of an old version that is still on demo server, I will update it to latest in a few days.

GeekoDev 7 years ago

Hi, this is because your server disabled this function, it is not a problem the module will work fine anyway, I will implement a check to not have this warning. I send you the updated file by mail.

GeekoDev 7 years ago

Hi howardal, yes the module works with any url type, CSV, XML, XLS, etc.
On demo only demo file types are allowed for testing.

Zeusy123 7 years ago

Alex is on holiday, so I will confirm for you, it does work with fastor:)

GeekoDev 7 years ago

Yes compatible with any theme :)

austurki@gmail.com 7 years ago

yes i use it with fastortheme ...it is working
https://www.goo.moda

GeekoDev 7 years ago

Yes this is possible for most of data of the store (product, category, information, customer, order), the rest of things must be set manually (custom fields, store config, currencies, etc).