rob/pms3

Table of Contents

This is something weird bug, which is happening only when we are uploading SKUs through Bulk Upload. And this happens with some random SKUs, this need to be checked and fixed someday for the system to work smoothly.

How to find there is problem

First of all, Orders those are using SKUs with buggy format stop working, as of now we are facing this in Direct Orders.
Check the Item table with the command select id, sku, title from Item order by id desc limit 200; and you will see some storage output

Output

Look into records no. 2140, 2133, 2098, and 2095. In these records, you will see the title of SKUs is a little bit moved left or not aligned properly. This is the problem with these records. so, first of all, we have to fix this problem

Steps to fix Item table problem

Go to Products-> Product List menu
Check for the SKU which is having a problem, you can get SKU from the above SQL Command. You have to scroll through the list because if you try to search that SKU, you will not find that.
Once you got the SKU, click on that SKU and open the Info link from the SKU pop-up. This will open the SKU information page.
Type the SKU manually in the SKU box e.g. if there is 202100 just delete that from the text box and retype manually do not copy paste.
Save the SKU This will solve the problem of the Item table.

Steps to fix Orders creating problem

First of all, Identify the Order No which is creating the problem, you can easily get that by clicking and opening the order.
When you have the Order say it is Order No. 714 then apply the following command
select id,sku,order_id,title from OrderLine where order_id=714;

Output in this you can see record no. 11581 has a little bit misaligned, just delete that single row and you will get order no 714 working back. Add that SKU to order afterward.