Search found 73 matches

Search found 73 matches

Re: Do you know where to find number or each product sold in the DB?

JNeuhoff wrote:
Mon Sep 14, 2020 12:36 am
straightlight wrote:
Sun Sep 13, 2020 3:36 am
In your OC admin reports.
Yes, in the admin backend at Reports > Reports > Products Purchased Report
Thanks! ;)

Jump to post
  • Mon Sep 14, 2020 1:43 am
  • Replies 11
  • Views 1451
Re: Do you know where to find number or each product sold in the DB?

kestas wrote:
Sun Sep 13, 2020 2:53 pm
I add OCMOD for this purpose. You can test and customize to your needs.
Thanks for the OCMOD! But how I am suppose to use it? I have installed but not sure how it works. I need to accsess the quantly of product sold for each product and able to control it.

Jump to post
  • Sun Sep 13, 2020 11:57 pm
  • Replies 11
  • Views 1451
Re: Do you know where to find number or each product sold in the DB?

thekrotek wrote:
Sun Sep 13, 2020 3:53 am
You need to query "order_product" table for this.
I have looked at it before and I coudn't find anything related to the quantity sold . Here are all the raws in "order_product"

order_product_id
order_id
product_id
name
model
quantity
price
total
tax
reward

Jump to post
  • Sun Sep 13, 2020 6:43 am
  • Replies 11
  • Views 1451
Do you know where to find number or each product sold in the DB?

Just like the title said, I have searched the database looking for the number of product sold for each product, and I coudn't find it, any tips?

Jump to post
  • Sun Sep 13, 2020 3:30 am
  • Replies 11
  • Views 1451
Re: I can't remove an extension from the module page.

Thank you guys for your help I found it in:

public_html/admin/controller/module/smsapi.php

O0

Jump to post
  • Fri Aug 21, 2020 9:24 am
  • Replies 8
  • Views 328
[SOLVED] I can't remove an extension from the module page.

Hello, I have complatly delete an extention and made sure that all files associated with the extension are deleted even from the FTP and the modification page, but still I can't remove it from the modules page in my store. Does anyone have any suggestions where do i look so I can remove it from the ...

Jump to post
  • Fri Aug 21, 2020 1:51 am
  • Replies 8
  • Views 328
Re: Question about customer's IP address

paulfeakins wrote:
Tue Aug 04, 2020 6:17 pm
Vector224 wrote:
Tue Aug 04, 2020 8:53 am
What do you guys think?
You could ban their email address or perhaps their name or address?
Hmm, is that a defult feature in OpenCart that I am not aware of?
Thanks for your comment

Jump to post
  • Tue Aug 04, 2020 9:57 pm
  • Replies 4
  • Views 381
Question about customer's IP address

Hi there, I am trying to ban a customer from accessing my website, but it seems like some customer could have the same IP, I noticed that with some customers even myself, I tried to check my own account and I saw like 250+ IP addresses under my account and I only use my PC and my smartphone why do I...

Jump to post
  • Tue Aug 04, 2020 8:53 am
  • Replies 4
  • Views 381
Looking to get a piece of advice from our fellows.

I own an online Marketplace using OpenCart + MultiMerch extension ( Multi-Vendor) and my website started to get really popular it has tans of data in the database and lots of products about 10,659 till this moment. and recently I started to feel that the website would take a quite a few times to loa...

Jump to post
  • Mon Aug 03, 2020 8:15 am
  • Replies 2
  • Views 198
Re: هل هناك طريقة لتتبع المبيعات من مختلف القنوات مثلا تويتر وفايسبوك

تقدر تنشئ روابط تتبع وستتخدم كل رابط تتبع لمنصة معينة
وهادي الخاصية موجودة بالأوبن كارت
وتلاقيها في قسم التسويق

Jump to post
  • Mon Aug 03, 2020 7:56 am
  • Replies 1
  • Views 450
Re: اريد عمل disabled للمنتجات التي تصل الكمية صفر

لا انصحك بتعطيل المنتجات التي تصل كميتها إلى 0 فهذا الشي سخفض من ترتيب موقعك في محركات البحث بل بالعكس انصحك بأن تبقي المنتجات فعالة وحتى ان كانت الكمية صفر حتى يتمكن الزوار من الوصول لموقعك ورؤية ما لديك من منتجات اخرى الحل الأمثل هو إخفاء هادي المنتجات من الأقسام والموقع بشكل تام ولكن ستضل روابط ا...

Jump to post
  • Mon Aug 03, 2020 7:53 am
  • Replies 3
  • Views 863
Re: How to Added Search Section Value?

Could you clarify your requirements? Do you want to search by author?

Jump to post
  • Mon May 25, 2020 12:49 am
  • Replies 2
  • Views 370
Re: الاصدار العربي 3.0.3.3

للأسف الاوبن كارت صار له عدة سنوات ما تغير وتقريباً كل النسخ ما بعد نسخة:
2.x
فيهم الكثير من المشاكل.

Jump to post
  • Sun May 10, 2020 3:38 am
  • Replies 1
  • Views 1425
Re: Emojis

Could someone tell me how to Log in as Root on the server and open the SQL ( or what does that mean?! )

Jump to post
  • Mon May 04, 2020 1:52 pm
  • Replies 4
  • Views 905
Google image feeds doesn't show the correct price for my products.

Hello, When I do an image search on Google and I search for any products on my website and I click on the image to see the product details Google adds extra 000 to the real price, so instead of 35.00, Google shows 35,000.00 although the price looks fine in my website, Does anyone know how to fix it?...

Jump to post
  • Sat May 02, 2020 2:08 pm
  • Replies 2
  • Views 181
Re: Conformation button at checkout page won't work ( ERROR 500 in console)

It turns out the issue was from ( Anti-Fraud IP) it was enabled and it has an IP that I blocked recently It looks like this anti-fraud system cause problems! More than 3 hours spent to solve it. I disabled the anti-fraud extension that comes with Opencart and it worked.

Jump to post
  • Sat Apr 04, 2020 6:12 am
  • Replies 12
  • Views 674
Re: سوال عن شامل الضريبة

sabilmart wrote:
Thu Apr 02, 2020 10:57 am
كيف اعدل على السكربت لاحتساب شامل الضريبه اي ان المنتج يكون شامل الضريبه
ما يحتاج تعديل خاص تقدر تضبط الضريبة من خلال
الإعدادات ومن ثم الضريبة

Jump to post
  • Sat Apr 04, 2020 5:28 am
  • Replies 2
  • Views 562
[SOLVED] - Conformation button at checkout page won't work ( ERROR 500 in console)

I am using Version 2.3.0.2 Customers can't place an order in my store due to an error at the check out page when they try to click on the confirmation button, and here is what is showing in the console: VM709:1 GET https://www.mywebsite.com/index.php?route=extension/payment/cod/confirm&_=15859470753...

Jump to post
  • Sat Apr 04, 2020 4:58 am
  • Replies 12
  • Views 674
Re: Is there any future for Opencart or its dying slow ?

What do you mean?

I'm on the forum every single day replying to questions and several other experienced OpenCart developers are also constantly replying to questions, usually in a matter of minutes!
Totally agree!

Jump to post
  • Fri Apr 03, 2020 1:01 am
  • Replies 28
  • Views 2790

Search found 73 matches