Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Try The Advanced Import Of Products Rate Topic   - - - - -

 
  • imac
  • CTO
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2040 posts

Posted 15 April 2018 - 11:02 AM #41

I haven't messed with the addon enough to know if it works or not but it sounds like modifiers need the ability to combine data from different columns.

 

For example in crazysharks case with categories:

Category - $valuecolumn1"///"$valuecolumn2

 

Another example where you have separate inventory from different warehouses and you need to add them together for the amount/quantity:

Quantity - $valuecolumn1+$valuecolumn2+...

This is not working for now. 

For now we are looking for the easiest solution. The things like using a value from another column may slow down the import and make it buggy(


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • imac
  • CTO
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2040 posts

Posted 15 April 2018 - 11:04 AM #42

One more Q.

What if you have 2 stores, then the store name must also set?

 

Above whas:

First field: Product_code - Second field: barcode - Third field: the amount of

 

96101 8,72E+12 4

96106 8,72E+12 6

96114 8,72E+12 2

96116 8,72E+12 9

96121 8,72E+12 13

96126 8,72E+12 3

96134 8,72E+12 0

96136 8,72E+12 14

96141 8,72E+12 8

96146 8,72E+12 2

I suppose you need to much only 1 and 3 columns, i.e. Product code and Amount.

This should work fine.


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • imac
  • CTO
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2040 posts

Posted 15 April 2018 - 11:09 AM #43

Hi imac

 

1- You are maybe wright but company sent this xml structure. All programmer dont now about xml stucture so we coudnt say all company your xml is wrong.

Example : I sent the private message before xml structure. This company is very old and has been doing the same since it was first established.

 

Soo if you build a flexible structure from scratch, there will be very few questions that come to you.

 

2- i coudnt add second image. how can add this??

 

3- in multivendor dev demo site cant work xml import.

2. Try to use "Advanced import: images" field : https://www.evernote...bjFWELIcxnhaDdk

It accepts all the images of product separated by comma, like

http://examlple.com/images/1.jpg,http://examlple.com/images/2/jpg

3. Ok, We'll check thank you


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3666 posts

Posted 15 April 2018 - 06:02 PM #44

imac,

 

Please allow .txt extension.  I know it works because I simply changed the extension from .txt to .csv and it read the file just fine but the file will be downloaded from url as .txt.



 
  • cristyxx
  • Member
  • Members
  • Join Date: 12-Sep 17
  • 37 posts

Posted 15 April 2018 - 07:26 PM #45

It will be great if in the Product Import Advanced will be an option to map category. Now we need to replace categories in CSV file to format (eg. Electronics///Computers///Desktop). In vendors files categories are not in this format.

Eg.link: https://www.simtechd...xml-import.html

 

Thanks !



 
  • richardfmm
  • Senior Member
  • Trial users
  • Join Date: 20-Apr 12
  • 240 posts

Posted 15 April 2018 - 08:21 PM #46

I suppose you need to much only 1 and 3 columns, i.e. Product code and Amount.
This should work fine.


Hi IMac,
YES/NO.
For now i want only the first and third column, but in the future i will use column 2 for barcode.
Now in the import i set the first line, the second line NOT and the third line for import.
After the import, i get the error ‘ import the file’.

 
  • richardfmm
  • Senior Member
  • Trial users
  • Join Date: 20-Apr 12
  • 240 posts

Posted 16 April 2018 - 03:06 PM #47

I suppose you need to much only 1 and 3 columns, i.e. Product code and Amount.

This should work fine.

 

Error is still there and ask 'Product type'



 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 17 April 2018 - 02:05 PM #48

.............



 
  • richardfmm
  • Senior Member
  • Trial users
  • Join Date: 20-Apr 12
  • 240 posts

Posted 19 April 2018 - 01:58 PM #49

Hi Imac,

 

When i change the second field column to replace('search', 'P', 'subject') then the import works and no error.

Is this the good way?



 
  • richardfmm
  • Senior Member
  • Trial users
  • Join Date: 20-Apr 12
  • 240 posts

Posted 19 April 2018 - 02:02 PM #50

Hi Imac,

 

How to do the import by Cron?

I must pickUP the file by FTP at the server of the client.



 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 19 April 2018 - 07:50 PM #51

................



 
  • richardfmm
  • Senior Member
  • Trial users
  • Join Date: 20-Apr 12
  • 240 posts

Posted 19 April 2018 - 07:55 PM #52

Hi richardfmm if second field dont use you were right but if you use all field how can you put product type so we can choose product type its useful.

 

Sorry, i dont understand you.



 

Posted 23 April 2018 - 01:55 PM #53

I have tested this addon and have a problem:

- impossible choose/save the csv delimiter

- can not be imported from URL protected by user and password

 


Fabrizio Aureli

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3666 posts

Posted 23 April 2018 - 02:00 PM #54

For URL try something like:

ftp://user:password@domain.com



 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 24 April 2018 - 10:05 AM #55

i want to say there category mapping field is good for usage.

 

 

1- i coudnt import category like this structure in dev.demo.cs-cart.com 

 

<Maincategory>Electronics</Maincategory>
<MaincategoryID>56</MaincategoryID>
<Category>Computer</Category>
<CategoryID>83</CategoryID>
 
Xml Structure Like this
 
<ProductList>
<product>
<ProductID>691</ProductID>
<ProductName>
iphone x 8
</ProductName>
<MainCategoryName>Electrconics</MainCategoryName>
<MainCategoryID>56</MainCategoryID>
<CategoryName>Phone</CategoryName>
<CategoryID>83</CategoryID>
<Price>3177.6</Price>
<Stock>1</Stock>
<Supply>1</Supply>
<Description>
<![CDATA[
<div style="width:614px"><p style="margin:5px 0"><b><i>İphone, <strong>x</strong>.</i></b></p><table width="100%" border="1" style="border-collapse:collapse; border-color:#999; margin:5px 0"> </div>
]]>
</Description>
<image1>
www.xxxxxx.com/upload/product/DRF691.JPG
</image1>
<image2>
www.xxxxxxxx.com/upload/product/DRF691_1.JPG
</image2>
<Resim3>
www.xxxxxxx.com/upload/product/DRF691_2.JPG
</image3>
<image4>
www.xxxxxxx.com/upload/product/DRF691_3.JPG
</image4>
<ListPrice>3972.00</ListPrice>
<Discount>20</Discount>
</product>
</ProductList>
 
 
2- And can use the product name in many places meta tag, meta description, product title, product search and so on, how do I do it.
 

3- i saw the other xml csv import "File Encoding" iso-8859-1 UTF-8 etc maybe its good idea for those with character problems

 

4- Some company gives Username Password for login, after Login then can take xml
 

5- in Selecting a file add "Select a file or enter a FTP" choice in google merchant center have get file from ftp acount why not we have

 

6- If have many products can have xml csv or file maybe good for usage

 

         Only price "update existing products"

         New Items: "Add" "Skip"

         Existing Items: "Update" "Skip"
         Identify Existing Products by Matching Field: "Model" "Sku" "MPC" "Product Code" "EAN" "MPN"
         Items in store but not in file: "İgnore" "Delete" "Disable" "Quantity Zero"
         Products per import segment: "20" "50" "100" "250" "500" "1000"
 
7- İn import Data menu Product import not show. https://prnt.sc/jcpnv5

 

8- Cron Job is perfect solution for usage

 

9-  if i get the file i see clicable link there. i click the "File -> General Setting -> File" link not run i get this result and get 404 page in dev.demo.cs-cart

 

admin.php?dispatch=import_presets.get_file&preset_id=1&company_id=1



 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 04 May 2018 - 09:04 AM #56

...................



 
  • imac
  • CTO
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2040 posts

Posted 07 May 2018 - 02:00 PM #57

Hi Imac,

 

How to do the import by Cron?

I must pickUP the file by FTP at the server of the client.

Take a look at this post: http://forum.cs-cart...ndpost&p=296309


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 07 May 2018 - 02:05 PM #58

..............................



 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 216 posts

Posted 10 May 2018 - 11:49 AM #59

Hi iMac. I am looking forward to this addon cs-cart for a long time. But none of them have a structure that can meet the demands completely. I have tested many xml products for a different product sample. I have seen some mistakes and think that it needs to be corrected. Having a slightly more flexible structure, I think that the wrong xml constructs that companies have distributed are suitable to fix faster.
I try to explain and write as much as I can about the mistakes I have encountered for this addon. I wish I could have a better structure.


 
  • imac
  • CTO
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2040 posts

Posted 14 May 2018 - 10:46 AM #60

 

Hi iMac. I am looking forward to this addon cs-cart for a long time. But none of them have a structure that can meet the demands completely. I have tested many xml products for a different product sample. I have seen some mistakes and think that it needs to be corrected. Having a slightly more flexible structure, I think that the wrong xml constructs that companies have distributed are suitable to fix faster.
I try to explain and write as much as I can about the mistakes I have encountered for this addon. I wish I could have a better structure.

 

Can you please send me more examples of XML files you are trying to import. Right now we are considering improvements in XML import


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug