i have just inserted one Product into Database and, if i add some images in the product edit screen, the app goes in crash:

I got this error message

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (scotchbox.product_images, CONSTRAINT product_images_product_id_foreign FOREIGN KEY (product_id) REFERENCES products (id)) (SQL: delete from products where id = 48)

From CreateProductImagesTable i tried to modify this column
$table->foreign('product_id')->references('id')->on('products')

to
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');

After a "php artisan migrate:fresh", the issue should resolve.

Regards

I started a fresh install but I am receiving 404 errors for files.
I have created the symlink (php artisan storage:link) for public/storage still no luck. Have I missed a step. Also the Installation link points to another fork for your project.

I'm not sure that it's really an issue but a get an empty collection from method listRoles() In EmployeeRepository

for now I replaced listRoles() with:

public function listRolesByEmployee(Employee $employee): Collection
{
return $employee->roles()->get();
}

kindly Regards

congrats for laracom, from the code it looks neat and clean, btw possible to add direct checkout feature?

Change

return $this->model->where($data)->all();

to return $this->model->where($data)->get();

Description
"Newest" and "Featured" categories are assigned to wrong ID's during initial seeding of the database.

This is the code from HomeController, that gets the categories based on statically assigned ID's and pushes them to front views:

public function index()
    {
        $category2 = $this->categoryRepo->findCategoryById(2);
        $category3 = $this->categoryRepo->findCategoryById(3);

        $newests = $category2->products;
        $features = $category3->products;


        return view('front.index', compact('newests', 'features', 'category2', 'category3'));
    }

but as the database is seeded by Faker including calling randomElement() method on an array of categories (database/factories/CategoryModelFactory.php)

$name = $faker->unique()->randomElement([
        'Newest',
        'Featured',
        'Gear',
        'Clothing',
        'Shoes',
        'Diapering',
        'Feeding',
        'Bath',
        'Toys',
        'Nursery',
        'Household',
        'Grocery'
    ]);

ID's of seeded categories will be different for each installation, e.g. in my case:
ID 2 is not "Newest", but "Diapering"
ID 3 is not "Featured", but "Household"

Probably these two root categories (Newest and Featured) can be moved to a static categories seeder, which currently seeds only "Uncategorized" at ID of 1? That would explain usage of static ID's of 2 and 3 in HomeController

Hello! First this project is awesome! I want to contribute.
My first suggestion is add product brand crud and associate with the product.

Hello,
I can't search on any controller/model
it looks laracom is using this module to make search query's

https://github.com/jarektkaczyk/eloquence/wiki/Base

"SQLSTATE[42000]: Syntax error or access violation: 1055 'laracom.products.sku' isn't in GROUP BY (SQL: select * from (select products.*, max(case when products.name = asd then 15 else 0 end + case when products.name like asd% then 5 else 0 end + case when products.name like %asd% then 1 else 0 end) as relevance from products where (products.name like %asd%) group by products.id) as products where relevance >= 0.25 order by relevance desc)

Hi the images for products aren't displaying. I have ensured I have run "php artisan storage:link" the images have loaded correctly in to "storage/app/public/products/xxxxxxxx.jpg"

Console is reporting a 404 "Not Found"

Any ideas

when we install laracom , i am getting following issues.can you help me?
C:\xampp\htdocs\development\priya>composer create-project jsdecena/laracom

In web.php line 20:

syntax error, unexpected 'namespace' (T_NAMESPACE)

PHP Parse error: syntax error, unexpected 'namespace' (T_NAMESPACE) in C:\xampp\htdocs\development\priya\laracom\routes\web.php on line 20
Script php artisan optimize handling the post-update-cmd event returned with error code 255

How can I use the Guest Checkout?

Another suggestion. Add on product table seo fields like, description, meta keywords and title

Hi,
first of all big thank you. Very good project and very nice that it uses latest laravel.
Can you please give me a hint what would be the right way to upgrade to bootstrap 4.0 in front-end?

The form for creating address does not contain field to add city and province, this breaks the code when admin tried to view user order details.

Hello guys,
Nice project so far but I'm a bit perplexed on how you manage the products associated to an order.

Schema::create('order_product', function (Blueprint $table) {
$table->increments('id');
$table->integer('order_id')->unsigned()->index();
$table->foreign('order_id')->references('id')->on('orders');
$table->integer('product_id')->unsigned()->index();
$table->foreign('product_id')->references('id')->on('products');
$table->integer('quantity');
});

As you can see in the above migration, you are not saving the sales price of the single item so, if the product price changes, the previous orders will be affected.

Am I wrong or that's a big issue?

Cheers

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Sierra Leone' for key 'countries_name_unique' (SQL: insert into countries (name, iso,iso3, numcode, phonecode, status, updated_at, created_at) values (Sierra Leone, SWE, QAT, 8, 1, 1, 2018-06-23 12:11:13, 2018-06-23 12:11:13))
Hi. Every time I run php artisan migrate --seed this error appeared. sometimes country name is changed and error appeared

Hi love your template. Do you have any intention on adding stripe as a payment gateway? Paypal in the UK use a different api system for online payments. and I can't set it up.

Thanks

https://laracom.net/#desc
https://laracom.net/#showcase

Both pages highlight the incorrect tabs. Would like to see this fixed, or a link to the website repo so I can fix it for you.

Hi i am trying to uploading some new items along with images in product section. Cover photo alone not getting stored in product folder but instead of that its getting stored inside XAMPP folder. At the same time image of the product are correctly stored inside the product folder.yeah i know u ll suggest me to try using homestead but im giving demo to college students through goDaddy shared hosting so kindly help me out.

Theory: https://en.wikipedia.org/wiki/Nested_set_model
Package: https://github.com/etrepat/baum

Unable to load products images

Being able to create customer groups and add customers to them. e.g. Retail, Wholesale etc.

Base table or view not found: 1146 Table 'my_database.sku' doesn't exist (SQL: select count(*) as aggregate from sku where sku = 123123)

Hello,
After installing laracom i found that the admin left bar can't open the submenu
even if i try to click on ".treeview"

Should i hardcode it again ? or it's a bug?

When I load a category page, the HTML was not rendered properly. Raw HTML was displayed on the view.

At the moment there is no way to add or remove a Role from an Employee.
An Admin employee cannot remove the admin role from another one.

I have a pr ready to submit:
As a part of a bigger enhancement this can be a first step to create a multi-role feature for Laracom.

Admin panel --> employee tab --> List employee --> edit,

after changing the status from disable to enable and after an update the status doesn't change.

Hello, I get 500 Internal Server Error when trying to register on your live Laracom.
I haven't tried it on my localhost though.

Question... How would you implement Electronic Fund Payment, that when a client adds a product into a cart, instead of going to stripe payment. It just generates Payment code like #234561234. And a bank name, with the amount to be transfered?

Description:

When trying to delete a product having 1 or more images associated in product_images table.

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (laracom.product_images, CONSTRAINT product_images_product_id_foreign FOREIGN KEY (product_id) REFERENCES products (id)) (SQL: delete from productswhereid = 49)

maybe add a cascade on delete in the migration file or a process to delete the associated entries in product_images first then remove its images in the products directory.

All images in the application are not visible. when i check the db and productimages table is empty. can you help me to resolve this issue. Thanks in advance.

Hello,
In databases it's great if you make the delete on cascade on all foreign keys,
for exemple if you make a new customer and a new address, once you destroy the customer; Addresses page doesnt work anymore, It throws an exception so you need to delete the address manually

• Create the Role / Permission CRUD
• Apply to employees
• Restrict access to certain pages

#68

At beginning I want to say that this is great work you made with laracom!

I noticed you start implemented product attributes. Do you have a roadmap when the feature will be finished?

Please I found out that the product page pagination is not working.
when I select a category the products in the category are not paginated even though I can see that the code is implement but is not doing the work.
Please can you just check and resolve the issue.

Also the front page products too should be limited to say 12 items per New Arrivals and Featured Products

i try to limit product per page in category page.

i can customize limit in search page.
return view('front.products.product-search', [
'products' => $this->productRepo->paginateArrayResults($products->all(), 10)
]);

how to limit product in category page?

hello,

how to configure paypal sandbox to test it from my localhost (http://localhost)?

i have an error

App \ Shop \ PaymentMethods \ Paypal \ Exceptions \ PaypalRequestError {"error":"invalid_client","error_description":"Client Authentication failed"}

After Successfully migrate tables and run php artisan serve.
I am seeing this page. Can you rectify why I am seeing these issues

Instead of shipping Laracom as a whole laravel app, it would make more sense to have it as a composer package. Then people have full freedom to build their ecommerce site as they want. Its also much easier for you/us to maintain.

Ill gladly help out on this.

+1

how to login laracom? in wiki im not see user admin and password

Being able to apply discounts either on order or order item base on a set of rules.
Great inspiration from Magento 2 and Sylius.

Hi everyone
After installing on Wamp php 7.0

please help!

Why I have this error??

In ProviderRepository.php line 208:

Class 'Sofa\Eloquence\ServiceProvider' not found

Description:
Currency labels are inconsistent throughout the project.
In many places they are hardcoded to PHP, for an example in admin/products/show.blade.php they are coded as <td>Php {{ $product->price }}</td>.

On this stage (unless there is a plan to support multiple currencies), currency name should be echoed as in admin/shared/products.blade.php <td>{{ config('cart.currency') }} {{ $product->price }}</td>

Quick search showed 8 results in 6 files:
admin/orders/list.blade.php
admin/orders/show.blade.php
admin/products/create.blade.php
admin/products/show.blade.php
admin/products/edit.blade.php
front/accounts.blade.php

This is quite easy to fix using find/replace in any modern editor (took me like 10 seconds on my local copy). I'm only a beginner when it comes to PHP tests and using github in general, so I'll just post it for now.

Kindly advise concerning admin access, failing to access it.

Otherwise thank you for the great work.

Often in Ecommerce the products have different prices and stock level in each country. Being able to define those in Laracom would be a great feature.