Jump to content

cjrhoads

Members
  • Posts

    45
  • Joined

  • Last visited

Profile Information

  • Location
    Berks
  • Activity
    User/Merchant

cjrhoads's Achievements

Newbie

Newbie (1/14)

11

Reputation

4

Community Answers

  1. Perhaps they are not responding to your request because it is very non-specific. What do you mean "it won't download"? Do you mean your FTP isn't working right, since that is what you might use to download? Or did you really mean install? In either case, it is an Add-On, which means the proper party to contact is the developer or company who created the Add-On. The truth is, the general terminology you are using would indicate that you don't really understand open source software, so perhaps you should stay away from it. I may have my problems with Presta-shop (I actually had to stop using it because my merchant account company changed all the security rules and the Prestashop updates were beyond my expertise to install. I got tired of paying programmers to keep the software running) but I re-iterate my point. The forums are free. The software is free. If you don't have enough technical expertise to make the software run, it is not the responsibility of the community forums to educate you on what to do and how to do it. If the software doesn't work, you have to be very specific to the specific developers of the part that doesn't work or you really won't get anywhere. In my book on Managing IT I use the analogy of going to a Dentist when you have a stomach ache. You need to know enough to at least know that you go to a dentist when your teeth hurt and you go to a doctor when your stomach hurts. Jmidgley is absolutely corrrect - you can't expect to use Presta shop, a free open source shopping cart and inventory management software, as if it is an off-the-shelf package with a paid staff of technical support people. The software is free - the labor to make it work is not. (This is the way it is with all open source packages.) I'm just sayin. Peace CJ Rhoads
  2. As I noted earlier, first you need to have the cpanel version of godaddy hosting, not the normal shared hosting. Prestashop does not work on normal GoDaddy hosting platform. If you have the Cpanel version of GoDaddy Hosting, there is an automated process that you use. YOU cannot manually install Prestashop following the typical directions because GoDaddy uses a different configuration, but they have set up an automated installation (that worked for me) that installed Prestashop using GoDaddy parameters. Once installed, don't try to install any updates automatically. Some work, some don't, so you have to pick and choose your updates. Best bet - call GoDaddy second level hosting support and have them walk you through the process. Just my opinion CJ Rhoads
  3. Well, I decided to stick with it once I figured out how to write sql queries to get the info I needed. I think someone else said it; this free shopping cart system is highly capable with lots of features but often provides just the bare bones. To get full functionality, you either have to be a good enough programmer to write the PHP statements, a good enough database person to write the SQL statements, or pay for one of the add ons that does it for you. I consider it a fair trade, as Prestashop still has a lot of capability that is not found in other free systems.
  4. Yes - I was able to write a SQL query to get the information. I looked at Nemo1 tutorial, but it was way over my head. I'm a database buff, but not a PHP programmer.
  5. Hi, Cleaner. I'm hoping someone else will answer as well, but I'm still doing what I started doing in July. I created a query that gives me the sales, and I run it every month. It seems to work pretty well. I now have dozens of other queries that I run. Once Prestashop posted the database schema (which wasn't available in July, but is now), it was easy to figure out which fields has the information I need so that I can simply write SQL queries for all my reports. Since I'm not really an SQL [spam-filter], what I actually have done is created an Access database structure that mirrors the Prestashop structure exactly (I used a software program called DBsync from DBConvert), and then I create my query using Access Queries (which I'm very good at). Then I view the SQL of the query, and copy and paste it into the New SQL window under Advanced Parameters--SQL Manager. Once it is set up, it is very easy to run each month. Anyone else find an easier way?
  6. Well - easy is tough, but I have to add that I did find a way to get a query that would give me a sales report. (See the thread on Sales Reports to see the SQL of the query). That means, Mike, that you could use a similar methodology to make a query that would give you the sales tax information that you need. (My non-profit doesn't pay sales tax, so I didn't include that info in my query - but you could easily do so). Regards CJ Rhoads
  7. Could be. I must mention that in another thread, someone shared with me the key table that I was missing. I can now get the sales information through a query so I don't have to look up each and every one. If anyone is interested, here's the query: SELECT ps_customer.company, ps_customer.firstname, ps_customer.lastname, ps_customer.email, ps_order_detail.product_name, ps_supplier.name, ps_order_detail.product_price, ps_order_detail.total_price_tax_incl, ps_orders.payment, ps_orders.date_add, ps_orders.invoice_date, ps_orders.delivery_date, ps_order_state_lang.name, ps_address.address1, ps_address.address2, ps_address.city, ps_state.iso_code, ps_address.postcode, ps_address.phone, ps_address.phone_mobile, ps_order_detail.product_reference, ps_orders.reference, ps_order_detail.id_order_detail, ps_order_detail.id_order, ps_order_invoice.id_order_invoice, ps_orders.id_customer, ps_product.id_supplier, ps_product.id_manufacturer, ps_order_state_lang.id_order_state, ps_address.id_state FROM ((ps_supplier INNER JOIN ((((ps_orders INNER JOIN ps_order_detail ON ps_orders.id_order = ps_order_detail.id_order) INNER JOIN (ps_address INNER JOIN ps_customer ON ps_address.id_customer = ps_customer.id_customer) ON ps_orders.id_customer = ps_customer.id_customer) INNER JOIN ps_product ON ps_order_detail.product_id = ps_product.id_product) INNER JOIN ps_order_invoice ON ps_order_detail.id_order_invoice = ps_order_invoice.id_order_invoice) ON ps_supplier.id_supplier = ps_product.id_supplier) INNER JOIN ps_order_state_lang ON ps_orders.current_state = ps_order_state_lang.id_order_state) INNER JOIN ps_state ON ps_address.id_state = ps_state.id_state WHERE ((Not (ps_order_state_lang.name)="test item")); (Note: this query is not meant to be copied and pasted verbatim, but just helpful if you already know how to do an SQL query and just don't know which tables to join. For example, I have a "test item" status that is not part of the default, so the WHERE clause won't do you any good. (Probably wouldn't hurt, but just to let you know I have not "sanitized" the example for general use.) Hope that's helpful.
  8. tuk66 said: >>This line of tables ps_product -> ps_order_detail -> ps_orders -> ps_customer can be joined in one query to get such a customer-product report. Wow!!! I don't know how I could have missed that! I completely missed the ps_orders linking table because it wasn't listed with the other ps_order_ tables. Tuk66 - you just saved me a ton of time and trouble. Thanks!!!! Thanks for the info, Nemo1. I'll check it out as well - it may become very useful! Now I have to go back in to all the forums where I wrote there didn't seem to be a table to join the info and reverse my comments. Thank you again. CJ Rhoads
  9. I think you got your answer, Mike. No, there doesn't appear to be a way to get that information easily. I could be wrong, but it appears that way to me after extensively reviewing the database schemas. Just my opinion CJ
  10. Thanks. We do know how to filter the list. But the orders screen only gives the customer name and order number, not the product they purchased. To find that out, we must actually click into each individual order. I was hoping for a report so that we didn't have to do that. It appears that Prestashop database scheme does not actually include any tables that can join to provide the customer, product, and order/payment information in a single report. Obviously, that is why there are no reports with this information in it. Instead, there appears to be PHP functions that allow programmers (but not non-programmers like me) to pull up the individual information for the individual customer and/or order. That's why the system can show a screen or a PDF with the information, but cannot generate a report with all that information in a table. We are reconsidering Prestashop as a result, but we will continue to investigate our options. In any case, thanks so much for taking the time to answer the question. I greatly appreciate it. Regards CJ
  11. Thanks for your reply. I appreciate it. We do know how to generate and save the invoices, but I was hoping for a report so that we didn't have to actually open and look at each individual page for each individual invoice in order to know what we sold. But apparently, a report with customer name, order number, and product name, quantity and payment information doesn't exist in Prestashop. Furthermore, there doesn't appear to even be a table in the dataset that we can query that would give us that information. We may end up switching to something else, but we will see. Thanks again. Warmest regards CJ Rhoads
  12. Sounds extremely interesting. Can you send me more info or put me on your mailing list? [email protected] Thanks CJ
  13. Have you considered concatenating the MainCategory name into the Subcategory name? You can do this easily in Excel by creating another column and entering the formula to concatenate the two. A B C 1 Main1 Sub =A1 & "_" & B1 2 Main2 Sub =A2 & "_" & B2 The third column will have Main1_Sub Main2_Sub You can't have two different categories with the same name regardless of whether or not they are under another category. CJ
  14. While I agree with you, jontobey, I must add that ALL shopping carts (indeed, all software) is written by developers without a clue as to how business actually works. It's the bane of my existance, but a reality that has not changed in the 25+ years that I've been in the field. (BTW - I am a serial entrepreneur, have started, developed, run, and sold several technology-based businesses, so I know of what I speak). The truth is that all software is poorly designed; the key is to figure out which programs have design flaws you can live with and which ones do not. Also - I guess I learned (the hard way) over the years not to trust that ANY software system does what it says it will do. 80% of them don't. Wishing they did doesn't change the ratio. So - be careful what you spend actual dollars on, and be absolutely sure that it does what you need before spending the money. For example, the whole world is littered with Quickbooks interfaces that don't work. (Quickbooks keeps changing their system, so many quickbooks interfaces work for about a year, and then don't work anymore - though vendors continue to sell them because there are many people who keep buying them even though they don't work.) I purchased perhaps a half-dozen before I finally faced the truth - you have to enter the information into Quickbooks manually. Period. Don't waste your time trying to get an interface. If you want your sales to go directly into Quickbooks, you have to use the Intuit/Quickbooks interface/merchant account system directly. Third party systems need not apply (anymore - since about 2012 when Intuit launched their own). Peace CJ
×
×
  • Create New...