Order creation working no more

  • bling007

    (@bling007)


    10 years, 8 months ago

    I cannot create any more new orders in woo. Ordering on website also doesn’t work. It has totally broken down the ordering system.

    I uninstalled and re-installed woo, but no luck. I cannot completely delete woo data for many reasons.

    The woo > order > “add order” redirects me to some post.php link which leads to white screen or opens the “posts” menu in admin panel.

    When ordered on site, it redirects me to wrong order-received page. The page used to show order details early on. Now it just says Thank you. The URL itself is weird and has “?key” in the end.

    Early on everything used to work.

    I “trashed” an order while editing an order created via woo > order > “add-order” (manually), it does show up in trash section. However, the row-actions are missing to restore an order or delete it permanently.

    Plus, restore that order redirects straight-away to “Posts” menu like the “Save Order” does.

    Its driving me nuts the way its going, please HELP !!! What am I supposed to do and how can I reboot my woo settings/setup without deleting products?

    https://wordpress.org/plugins/woocommerce/

Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    I would suggest you first turn all plugins off except WooCommerce ( all ). Then go to your permalinks settings and click on save/update twice. Re-test your issue.

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Doesn’t work. I deactivated all the plugins, except woo and saved permalinks as you mentioned.

    When I manually add order (via admin) and hit “save order” – I am taken to http://www.mysite.com/wp-admin/edit.php which is actually the posts menu inside admin panel.

    I should be in the woo > order menu itself after successfully creating an order !

    The permalinks are pretty permalinks based on /postname — I need this cause I am using iOS app.

    I tried default, but still no luck. Its getting weirder and weirder. I have 0 orders in my database and new are not getting created.

    I check DB tables, wp_woocommerce_orders — it seems fine. But maybe I need to check how it appears for a normal order so I can debug something.

    I have not edited any file in woo. And today itself updated to 2.4.7

    I even tried 2.4.6 but its not working in it either.

    Any other possible solution?

    in anyway, can I create a dummy order inside woocommerce ? I feel perhaps it might do the trick. Or re-install / reboot woo settings (only settings).

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    I think I might have gotten the problem. I thoroughly checked DB tables for my installation and a demo working installation.

    The findings are shocking much.

    In DB table wp_woocommerce_order_itemmeta the following shortcodes/entires are missing for each order entry:

    _product_id
    _variation_id

    It does make sense now why orders don’t get created. How can I re-instate this? I am not a pro at this but I can definitely figure it out if guided.

    Again, I might be wrong too. But someone please help me out, I am in middle of crisis as my business is taking a huge hit.

    Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    In your database table wp_options check to see if woocommerce_db_version matches your WooCommerce version.

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Yes it does

    Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    Ok try this. First backup your database. Then manually trigger the WooCommerce data update again by going here.

    http:/YOURSITE/wp-admin/admin.php?page=wc-settings&do_update_woocommerce=true

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    it logs me out all the time I try to access that url

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Ok it was some kind of caching problem I guess. I finally did what you said, result = no luck.

    Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    Do you have some special SSL settings on your site? Try it with https:// instead.

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    No, I don’t have SSL. I got the url to work, but it did not help

    Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    Yeah it would be hard to diagnose your issue without having access. So I would recommend you open a ticket with WooThemes here so someone can access your site https://support.woothemes.com/hc/en-us

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Can’t you tell me how to insert _product_id and _variation_id in wp_woocommerce_order_itemmeta ?

    It does make sense that orders are not getting created because they lack product_id

    I am manually adding products in my orders, then why are they not getting store? Forget that, why is product_id not present in the order_itemmeta — if its blank its one thing, its MISSING !

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Anyway I can add these two : _product_id and _variation_id in each wp_woocommerce_order_itemmeta ? by a function or something?

    Plugin Contributor royho

    (@royho)

    10 years, 8 months ago

    Perhaps try adding a new product and test the checkout again only with that new product you just created. See what the results is for that.

    Thread Starter bling007

    (@bling007)

    10 years, 8 months ago

    Tried all of that before taking to this forum sir !

Viewing 15 replies - 1 through 15 (of 15 total)

The topic ‘Order creation working no more’ is closed to new replies.