[US website] 12/26 Import function

[lihaolihao]

There are five plug-ins we need to check And has a "Magestore/Bannerslider" I can't find it

[kevin-doselection]

Keeps "yotporeviews" active Removes "m2epro_ebay_magento", this is not been used ("m2epro_ebay_magento", is been disabled.)

[lihaolihao]

It's still having problem.I only removes "m2epro_ebay_magento",and how do you test "yotporeviews" in order to keep it active.At last,please tell me if I can test other,thk.

[kevin-doselection]

"yotporeviews" is an extension effecting product detail page, not order.

Next we can try "Raveinfosys_OrderExporter".

[lihaolihao]

not "Raveinfosys_OrderExporter",next which can we try

[kevin-doselection]

Do you know what is the extension name for order import?

[kevin-doselection]

At Configuration>Advanced>Advanced we can check is it disabled

[lihaolihao]

I need to check the extension name

[lihaolihao]

this extension are about order import

[kevin-doselection]

Besides the chance that extension affecting the import order status, solely single file might be the answer. I would check on SunshineBiz_OrderImportExport whole folder, compare at Core Local. See is there any clue.

[lihaolihao]

Do you check it?I have checked on "SunshineBiz_OrderImportExport" code,you can see file on "\ltsport.com\html\app\code\community\SunshineBiz\OrderImportExport\Model\Import\Entity\Order.php" and check line 221 . And other extension need to check,pls tell me tomorrow,thk.

[kevin-doselection]

You sure it is Line 221? I only see "}" on that line.

[lihaolihao]

sorry,my file is old.I upload the new,and you can cehck file between 225 lines and 324 lines.Focus view line 313,it's about order status.

[lihaolihao]

@kevin-doselection I know where is a problem.pls check file "/ltsport.com/html/app/code/local/Mage/Sale/Model/Order.php" line between 2145 and 2153.This file will change order status.I have been tested.so now we only need to change judgment condition,this problem will be solved.

[kevin-doselection]

Good job. Please test more order to check is there any side-effect.

[kevin-doselection]

Big issue: the order can be process, but it won't be "Completed" after created label.

[lihaolihao]

Before I haven't started to change,so there is a problem.Now I modify the code in "/ltsport.com/html/app/code/local/Mage/Sale/Model/Order.php".Please look at the red circle in the picture ,it's OK. Upload function has been able to use,pls check it.

[lihaolihao]

[kevin-doselection]

1. We can test more order at once next step. Please explain the process to do it here or in PDF.
2. Check on Order # 100006933, it should be "completed". Please check the code.

[lihaolihao]

what's problem on Order # 100006933,it's "completed".

[lihaolihao]

Original import file 3.pdf

[lihaolihao]

https://www.dropbox.com/s/h71b5nu32mmxb7p/Original%20import%20file%203.csv?dl=0

[kevin-doselection]

Hello, some order will not become "Completed" after created label(not right), some order will(normal). If you check on order activities on the order detail page at the bottom, you will see 2 Processing. One of them should be "Completed", but instead, it still showing Processing.

This required attention.

[kevin-doselection]

For now, I was manually choose "Shipped" and it will become "Completed" eventually.

[lihaolihao]

Hello,kevin,I found thst all problems's orders were paid by Credit Card ( First Data ) .Now I have modified the code,pls check this payment type and tell me the results,so I can know if it will succeed,thank.

[lihaolihao]

And pls check whether other payment type are affected

[kevin-doselection]

PayPal also. Order 100006953

[kevin-doselection]

The order status was auto-change to Completed, after we updated it with Shipped. Now order 100006967 will not change to Completed, after we updated it with Shipped. This order is placed via PayPal.

[kevin-doselection]

Hello, I want to confirm that the import function is right.

Process: Action 1: Import new order (Status: Invoice required) Fact: Account received payment (Manually) Action 2: Import order for updating tracking number or ShipStation create shipping label (Status: Completed)

According to above, import function should be able to recognize New and Shipped order. Also, could you set fixed default status (Invoice required) for new order? Update fixed status (Completed) to updating order too. We don't want user can decide the order status.

[lihaolihao]

https://www.dropbox.com/s/lt1i1zmn9rlgd8h/%E7%AC%AC%E4%B8%89%E7%A7%8D%E5%AF%BC%E5%85%A5%E6%A0%BC%E5%BC%8F.zip?dl=0 read this

[kevin-doselection]

PayPal order from Magento is not getting message from ShipStation. That caused the order status still remain "Processing". Please check.

[lihaolihao]

Follow up,do not use the 'Original import file 3' first,thank.

[lihaolihao]

Now whst's Paypal orser status

[kevin-doselection]

All good now.

[kevin-doselection]

Is it ready for final testing?

[lihaolihao]

No,'Original import file 3' will affect other website's order status,need to find resolvent.

[kevin-doselection]

Since PayPal payment method is having issue. Is it possible change it to "cashondelivery" or "checkmo"? Perhaps it will avoid the issue that affecting the order status.

[kevin-doselection]

New import format from Groupon, default phone# use 6269658813 Please let me know it's finished. merchant_17967_orders_20161205.xlsx

[lihaolihao]

I modify the code, please follow up on whether it will affect other orders,thank!

[kevin-doselection]

FYI 12/10 Order # 100007152 was completed when she just placed the order. So far no issue, follow up.

[kevin-doselection]

Please send me a template about import format for normal order and Groupon

[lihaolihao]

ok,follow up,need more information.

[lihaolihao]

https://www.dropbox.com/s/r223zbzjyj7cvnr/Desktop.zip?dl=0 template about import format

[kevin-doselection]

Help me double check "Kevin_import" is okay. This format is more user-friendly.

[lihaolihao]

I only see this,it's not "Kevin_import".What's problem here?You took the first step,then order status is changed to 'processing',but you canceled it later.

[kevin-doselection]

Yes, I was testing about the function. The import is "Kevin_import", file as below. So far, no problem. Help me double check testingorder.xlsx

[lihaolihao]

yes,it's ok.

[kevin-doselection]

1. New import format from Groupon, default phone# use 6269658813 merchant_17967_orders_20161205.xlsx

2. New import format from eBay VIP 12-19-2016 order.xlsx

Please let me know it's finished.

[lihaolihao]

1.New import format from Groupon is ok.Upload files in the link below 链接: http://pan.baidu.com/s/1hsmetla 密码: ng3e

[lihaolihao]

2.New import format from eBay VIP,There is a problem with the order check.Do you know what's problem?

[kevin-doselection]

1. will test
2. sku not exist try this "CB-SU-4D,SR-ST-2400-207-WS". Also kevin_ebay_vip is working